Entity Dimension Member Limit: Best Workaround
Summary
Seeking advice on how to work around the PBCS 50,000 member limit on the Entity dimensionContent
I have several on-premise applications that have repurposed the Entity dimension as Project. These renamed and repurposed dimensions have more than 50,000 members. In PBCS, there is currently a 50,000 unpublished member limit on the Entity dimension. If you try to import metadata or a snapshot that breaks this threshold, you get something like the following:
/Global Artifacts/Common Dimensions/Standard Dimensions/Projects :- Load failed for the following reason - Unable to add new members as the number of members in the dimension exceeded the threshold. Criteria: Number of members Error Threshold: 50000 Warning Threshold: 50000 Current Value: 118241