Understanding Best Practices for Hierarchy Management
- 1 Minute to read
- Print
- DarkLight
- PDF
Understanding Best Practices for Hierarchy Management
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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).
Was this article helpful?