Set attribute types so that they are compatible

This rule analyzes dimensions to determine whether they contain attributes that are of compatible types.

Except for attributes that map to the Regular type, a dimension should not typically contain attributes of different types. For example, you would not mix attributes that have geography and product types in a single dimension.

When two or more attributes in a dimension are of types that are not compatible, you should make sure that the Type property of each attribute is set correctly. Alternatively, you might consider removing the incompatible attributes from the dimension.

For more information about the attribute types available in Analysis Services, see Configuring Attribute Types in SQL Server Books Online.

Community Additions