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).