MicroStrategy ONE
User Group Hierarchy
A MicroStrategy User can have either a direct relationship with a User Group or an indirect relationship. For example, a user can be in a user groups. Additionally, a user group can be nested in another parent user group. The User Group relationship tables store the recursive relationship between accounts and the corresponding user groups. This is illustrated in the examples at the end of this section.
lu_user_group
The list of User Groups is the MicroStrategy metadata. This table stores information specific to MicroStrategy metadata. Badge accounts do not belong to metadata user groups. Therefore, all Badge Accounts are assigned default value as MicroStrategy Badges.
|
Column |
Description |
Data-Type |
|---|---|---|
|
user_group_id |
The auto-generated ID of the User Group. |
bigint(20) |
|
user_group_guid |
The metadata GUID of the User Group object. |
varchar(32) |
|
user_group_name |
The name of the User Group stored in the metadata. |
varchar(255) |
|
user_group_desc |
The description added in the properties dialog box for the User Group object. |
varchar(512) |
|
metadata_id |
The ID for the corresponding metadata for each User Group. All User Groups are stored at the metadata level. |
bigint(20) |
|
creation_timestamp |
The UTC timestamp of when the user group was first created in the metadata. If a script was used to import a list of users, the timestamp may be identical for the user groups. |
datetime |
|
modification_timestamp |
The latest UTC timestamp from when the user group object was last changed. The value will continually update as the object is modified. |
datetime |
|
user_group_status |
The latest status of the User Group object in the metadata. The status can be: Active Deleted |
varchar(25) |
| user_group_version | The version ID of the User Group. | varchar(32) |
rel_account__usergroup
The relationship table between Microstrategy user objects and the immediate parent user groups in the metadata. This table does not store indirect relationships between users and user groups. This table will not have a row for user groups that does not have a user directly in it.
|
Column |
Description |
Data-Type |
|---|---|---|
|
account_id |
The ID of the account that belongs to the corresponding User Group. |
bigint(20) |
|
user_group_id |
The User Group ID for which the account corresponds to directly. |
bigint(20) |
rel_childuser__usergroup
This is a relationship table between Microstrategy User Groups and their parent User Groups in the metadata. A single User Group can be a child to multiple parent User Groups, which could recursively belong to other parent User Groups. This table is specifically used to form the recursive relationship between User Groups and all parent User Groups (direct or indirect). All indirect relationships are resolved to create a direct relationship in this table.
|
Column |
Description |
Data-Type |
|---|---|---|
|
child_group_id |
The ID of the child user which belongs to the corresponding parent User Group. |
bigint(20) |
|
user_group_id |
The parent User Group ID. |
bigint(20) |