1. Administrator's Guide
  2. Working with Standard Profitability
  3. Working with Standard Profitability and Cost Management Dimensions and Members
  4. Dimension Types

Dimension Types

There are several dimension types.

  • System dimensions, such as the Measures and AllocationType dimensions, must be created based on the requirements listed in these sections:

  • Alias dimension is used to assign alternate names, descriptions, languages, or other items that help to define dimensions.

  • Business dimensions are created to describe the business elements within the model, such as departments, general ledger accounts, activities, customers, or products. See Business Dimensions.

  • Attribute dimensions enable analysis based on the attributes or qualities of dimension members. Attributes describe characteristics of data, such as the size or color of products.

  • User-defined attributes (UDAs) enable analysis based on text attributes that can be used to classify members of another associated dimension. For example, you may add a UDA called "New Products."

  • POV dimensions indicate a specific point of view or version of the model, such as year, scenario, or period. At least one POV dimension is required for each model.

    You can also create a Version dimension type to maintain separate versions of the same POV. The version is used to track different versions of the same model and evaluate the impact of changes or different strategies on the model.

Note:

When defining dimensional outlines, there are restricted characters that may not be used for naming. Oracle strongly suggests that you review the Oracle Essbase naming conventions in the Oracle Essbase Database Administrator's Guide.