Export (0) Print
Expand All
Expand Minimize
0 out of 3 rated this helpful - Rate this topic

Avoid creating hierarchies where attribute relationships do not exist between one or more levels

This rule analyzes each user hierarchy to determine whether levels exist that are not related to each other through attribute relationships.

For best performance, you should typically avoid creating hierarchies where attribute relationships do not exist between one or more levels. Having attribute relationships between every level in a hierarchy makes the hierarchy strong and enables significant server optimizations.

For more information about how to configure attributes and user hierarchies, see Defining and Configuring a User-Defined Hierarchy and Specifying Attribute Relationships Between Attributes in a User-Defined Hierarchy in SQL Server Books Online.

For more information about performance issues related to attributes and user hierarchies, see the section, "Effectively using hierarchies," in the SQL Server 2005 Analysis Services Performance Guide.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.