In this page:
Table of Contents |
---|
Overview
User inbound interface is designed to load data into the following DB tables:
...
Microstrategy Model Processing Details
microstrategyRole can get the following valid values (MSTR_ROLE code category):
- 1 - Consumer;
- 2 - Writer;
- 3 - Administrator.
microstrategyUserStatus can get the following valid values (MSTR_USR_STATUS code category):
- 1 - ACTIVE;
- 2 - INACTIVE;
- 3 - DELETED.
Deleting User
To delete a user, make sure you have set header/action = ‘DELETE’, the User will be deleted, and the followings elements:
- userId
- updateSource
Switch Off Password Encryption
If you load data thru the panel, user password is encrypted by default. To switch off encryption, you should add a header/processingOptions element with "APPLY_NO_RULE_password" value:
Code Block | ||
---|---|---|
| ||
<EagleML
xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
eaglemlVersion="2-0"
eaglemlType="UserAdministrationTransactionMessage"
xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd"
xsi:type="UserAdministrationTransactionMessage">
<userAdministrationTransaction>
<header>
<objectType>User</objectType>
<processingOptions>APPLY_NO_RULE_password</processingOptions>
</header>
<user>
<objectType>User</objectType>
<objectId>User</objectId>
<objectDescription>User</objectDescription>
... |
Passing tag 989
Info |
---|
Available on 17R2 environments only. Stored procedures and panels do not contain tag 989 on other versions. |
The tag 989 with ‘EXACT’ value is passed to User and Center Role lookups (qusersummary and qroles panel) in the User and User Group inbound interfaces.