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 of 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.
Reinsert Mode
Default mode for assigning Center and Pace Roles to a User is UPSERT.
REINSERT mode is also available. In this mode all Center and PACE roles are removed from user and only roles from incoming User file are assigned.
To run User update in REINSERT mode you should set <processingOptions>REINSERT</processingOptions> in userAdministractionTransaction header. Like this:
Code Block | ||
---|---|---|
| ||
<userAdministrationTransaction> <header> <objectType>User</objectType> <processingOptions>REINSERT</processingOptions> </header> ... |