Understanding Best Practices for Hierarchy Management

The following are the best practice recommendations to consider for maximizing performance. Note that these suggestions are only guidelines and do not guarantee any specific level of performance.

• Limit the maximum number of members to 10,000 in a single-dimension hierarchy.
• Reduce the number of levels in your attribute hierarchy for better performance, with a maximum of 5 levels.
• Keep the number of attributes per dimension to 5 or fewer (although up to 10 attributes are supported).