Attribute Dimensions

Attribute dimensions are a special type of dimension that are associated with a business dimension, and contain members that can be used to classify members of another, associated dimension.

Attribute dimensions describe characteristics of data, such as the size and color of products.

You can use these attributes to analyze data, based on the attributes or qualities of dimension members. The attribute dimensions are also used for filtering destination intersections when assignment rules are created.

Note:

For naming restrictions, see Essbase Naming Conventions.

There are two Attribute dimension types:

• Attribute Dimensions:

  • The attribute can be created using different structures, such as Boolean, Date, Numeric, and Text.

  • An attribute has a hierarchy, and the hierarchies can be rolled up for aggregate values.

  • Only one attribute from a given attribute dimension can be associated with one member.

• User-Defined Attribute Dimensions (UDAs):

  • The attribute can only be created using Text.

  • A UDA does not have a hierarchy and cannot be easily used in reports to generate sums.

  • Multiple UDAs can be associated with one member.

Each type of attribute dimension offers different advantages, depending on your model and reporting needs. For detailed information about working with attribute dimensions, see the Oracle Essbase Database Administrator's Guide.

You can use these attributes to analyze data, based on the attributes or qualities of dimension members. The attribute dimensions are also used for filtering destination intersections when creating assignment rules.

For naming restrictions, see Essbase Naming Conventions.