1. Database Administrator's Guide for Oracle Essbase
  2. Work with Essbase Attributes
  3. Process for Implementing Attributes

Process for Implementing Attributes

The following process explains the order of actions for implementing attributes in your Essbase cube.

  1. Create a dimension.

    In an application workbook on the Essbase.Cube Worksheet, or in the outline editor, position the attribute dimensions after all standard dimensions.

  2. Tag the dimension as an attribute dimension and set attribute dimension type as text, numeric, Boolean, or date.

    See Attribute Dimension type.

  3. Consider whether non-aggregating attributes would be useful in your database. See Non-Aggregating Attributes.

  4. Add members to the attribute dimension.

  5. Associate a base dimension with the attribute dimension.

    See Restrictions for Attribute Dimension Association.

  6. Associate members of the base dimension with members of the attribute dimension.

    See Restrictions for Attribute Member Association.

  7. If necessary, set up the attribute calculations.

    See Calculate Attribute Data.

Other References