Understanding Best Practices for Hierarchy Management
  • 1 Minute to read
  • Dark
    Light
  • PDF

Understanding Best Practices for Hierarchy Management

  • Dark
    Light
  • PDF

Article summary

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?