Explorer - Entity View RRS feed

  • Question

  • I have an entity with 10000 odd leaf members. I can view these members, apply filters etc. Looked at paged view of all 10000 members when I use the explorer. I have used ssis to load another 10000 records. However, they do not appear in the explorer when I refresh (and go back to the explorer > entity. I know they are there because when I use the filter I can filter and discover newly added members in the explorer. I want all 20000 members in the page display to appear when I first go into the explorer. When I load the entity in "Denali" Excel add in all 20000 members are loaded. I know I might be missing something basic but can anyone explain why I am not seeing all members when I refresh and first use the explorer?

    Thank you.

    Regards AB
    Wednesday, September 14, 2011 3:13 AM


  • There is an issue in the MDS staging process where if you stage data into a version that is not flagged, the member counts are not set to be updated.


    The member counts are actually calculated and stored in the mdm.tblsusermembercount table.  Counts are stored by user and entity.  When an action occurs that would results in a change in the member count (i.e. addition or deletion of a member), the counts in this table are set to “-1”  which indicates that the counts must be recalculated.  Then the next time the user opens an entity, MDS sees that the count is set to -1 and will recalculate the member count and update the table.


    The issue is that the staging process is not setting the count to -1 in the above table if the version is not “flagged”, so the counts are not getting updated.


    This can be prevented in future staging processes by  flaging the version you staging data into. 

    For the existing data, you can force a recalculation by setting the LastCount column in this table to -1.  This will force the member count to be recalculated the next time the user opens an entity.



    Pam Matthews



    • Proposed as answer by Pam Matthews Wednesday, September 14, 2011 2:41 PM
    • Marked as answer by CubeWarehouse Wednesday, September 14, 2011 10:02 PM
    Wednesday, September 14, 2011 2:41 PM