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.
Regards,
Pam Matthews
www.profisee.com
