EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB47710: User and User Group reporting in MicroStrategy Enterprise Manager

Community Admin

• Strategy

User and User Group reporting in MicroStrategy Enterprise Manager

In Strategy Enterprise Manager, User - User Group relationship is tracked using the following 2 relationship tables.

  • IS_USR_GP_USER
  • IS_USR_GP_USR_GP

Consider the following User - User Group hierarchy in the metadata. The numbers denoted in parenthesis are the EM_USER_ID and EM_USR_GP_ID associated to each and user group in the Strategy Enterprise Manager Warehhouse.
 
UserGroup1 (1)
User1 (1)
User2 (2)
UserGroup2 (2)
  User3 (3)
  User 4 (4)
  UserGroup4 (4)
    User5 (5)
    User6 (6)
UserGroup3 (3)
    User7 (7)
    User8 (8)
The above structure is represented as follows in the IS_USR_GP_USER table in Strategy Enterprise Manager:
 

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

 
The nested user group structure is represented in the IS_USR_GP_USR_GP table as follows:
 

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

MSTR_MEM_CACHE_MAX_BLOCK_SIZE = 32 MB
 *MDX does not allow attributes from different hierarchies within the same dimension to be used on the same report. Therefore, if the template attribute is not in the same hierarchy, it must also be in a different dimension.EM_USR_GP_IDEM_USER_IDIS_REPOSITORY_ID111121231241371381451461EM_USR_GP_PARENT_IDEM_USR_GP_CHILD_IDIS_REPOSITORY_ID121131241

 
 
Also, in the Strategy Enterprise Manager project, an explicit relationship between the 'User' and 'User Group' attributes are defined exclusively within the schema as shown below.
 

ka04W000000ObeRQAS_0EM4400000029Nq.jpeg

 
 
The nested user groups are tracked using the User Group (Parent) and User Group attributes as shown below. Each User Group can have ONLY one User Group (Parent) indicating that this relationship is to track immediate parents group and not the entire nested structure.
 

ka04W000000ObeRQAS_0EM4400000029Nj.jpeg

 
 
For the same User - User Group structure example given above, Enterprise Manager reports will show the data as given below.
 
A report with attributes 'User' and 'User Group' will just show the immediate parent for each user and not the nested group structure.
 

ka04W000000ObeRQAS_0EM4400000029Nn.jpeg

 
 
If the attribute 'User Group (Parent)' is added to the above report, the data is as shown below. As seen in the resultset below, the user - user group relationship is correct, and the nested group relationship is correctly represented. In this example, User Group4 is shown associated to parent User Group 2, and User Group2 in turn is seen as a child of User Group1. It is however not possible to show a visual nested user group structure with a report in Strategy Enterprise Manager.
 

ka04W000000ObeRQAS_0EM4400000029Np.jpeg

 
 

Comment

0 comments

Details

Knowledge Article

Published:

May 18, 2017

Last Updated:

May 18, 2017