Working with Attributes
Use attributes to group members using the same criterion. You can assign attributes to sparse dimensions only. You can't assign attributes to label-only members. Attribute dimensions don't have aggregation properties because parents are dynamically calculated.
The Account dimension is usually defined as dense, so you can't assign attributes to it unless it's changed to sparse for all cubes. If you change a dimension from sparse to dense, all attributes and attribute values for that dimension are automatically deleted.
Attributes can have data types of text, date, Boolean, and numeric, as described in Understanding Attribute Data Types. Attribute names must conform to guidelines listed in Naming Restrictions. When attributes are defined, you can use the Member Selection dialog box to select attribute functions, such as Equal and GreaterOrEqual.
Note:
This topic documents how to work with attributes using the Classic Dimension Editor. For information about using the Simplified Dimension Editor to work with attributes, see Working with Attributes.
To create and change attributes, attribute values, and aliases:
Related topics
Note:
Instead of explicitly filtering by an attribute (like Red, for instance), you can create a user variable for the attribute dimension, and then use the user variable as the filter. Then you can enable the user variable as a dynamic user variable which would allow users to change the value of the filter at runtime. This is a useful technique that allows for dynamic filtering. See Managing User Variables.