Dela via


Design Warning Rules (Analysis Services - Multidimensional Data)

This section of the documentation contains cause and resolution information for database design warning rules related to Microsoft SQL Server Analysis Services. 

Design Warning Categories

Dimensions

Aggregations

Partitions

Attributes and Attribute Relationships

Measures and Measure Groups

User-Defined Hieararchies

ROLAP and MOLAP Storage

Data Providers

Error Handing

Dimensions

Aggregations

Partitions

Attributes and Attribute Relationships

Avoid defining many-to-many relationships when either the intermediate measure group or any of the intermediate dimensions have 1 million or more rows

Avoid defining non-aggregatable attributes in a parent-child dimension with the exception of the parent attribute

Avoid diamond-shape relationships not covered by hierarchies

Avoid redundant attribute relationships because these relationships may prevent data from being aggregated when the granularity attribute of a cube is a non-key attribute

Avoid specifying more than one non-aggregatable attribute per dimension

Define attribute relationships as 'Rigid' where appropriate

Define the default member for non-aggregatable attributes in either the DefaultMember property or the cubes' MDX script

Either disable the attribute hierarchy or set the AttributeHierarchyOptimizedState property to NotOptimized for non-key attributes that have 1,000,000 or more members and a cardinality within 95% of the key attribute

Set 'Account' and 'Time' attribute types so that they are compatible with the dimension type

Set attribute types so that they are compatible with the dimension type

Set at least one of the attribute types to match the 'Account' or 'Time' dimension type

Set at least one of the attribute types to match the dimension type

Set attribute types so that they are compatible

The names of attribute relationships should match the names of the related attributes

Use numeric key columns for attributes with 500,000 or more members

Arrow icon used with Back to Top linkBack to Top

Measures and Measure Groups

User-Defined Hierarchies

ROLAP and MOLAP Storage

Data Providers

Error Handling