1. Using Oracle Essbase
  2. Create and Manage Cube Outlines Using the Web Interface
  3. Set Dimension and Member Properties
  4. Set Attribute Associations

Set Attribute Associations

When manually working with attributes, use the outline editor and the Attributes tab in the member inspector. First you associate attribute dimensions with base dimensions and then you associate attribute members with members of the base dimension.

Attributes are associated with Base dimensions; base dimensions are sparse standard dimensions containing members with which you would like to associate attributes.

Associate an Attribute Dimension with a Base Dimension

To associate an attribute dimension in <yourapplication> with a base dimension:

  1. Open the outline:

    In the Redwood Interface,

    1. On the Applications page, open <yourapplication> and then open the database (cube).
    2. Click Launch Outline.
    3. If the outline is locked, and you are an administrator, click Unlock outline Image of the Unlock outline icon in Redwood..

      Before you forcefully unlock a locked outline, make sure that no one else is working with it.

    In the Classic Web Interface,

    1. On the Applications page, expand <yourapplication>.
    2. From the Actions menu to the right of the cube name, select Outline.
  2. Select a base dimension to which you want to associate an attribute dimension. For this exercise, choose Market.
  3. If you are not already in Edit mode, click Edit.
  4. Right click on Market and select Inspect.
  5. Click Attributes.
  6. Select an attribute dimension, for this exercise, select Intro Date from the Attribute Name column.
  7. Click the right arrow next to Associated Attributes to associate the selected attribute to the regular dimension you selected in step 4.
  8. Click Apply and close.
  9. Click Save to save the outline.

After you associate an attribute dimension with a base dimension, you must associate members of the attribute dimension with members of the base dimension; these members must all be from the same level in the base dimension.

Associate an Attribute Member with a Member of the Base Dimension

To associate an attribute member in <yourapplication> with a member of a base dimension:
  1. With the <yourapplication> outline still open, click Edit.
  2. Expand Market, then East and select New York.

    New York is the base member to which we'll associate an attribute.

  3. Right click on New York and select Inspect.
  4. Select Attributes.
  5. Select the attribute member you want to associate with New York.
    • In the Redwood Interface, select the down arrow in the Population row and select the member.
    • In the Classic Web Interface, from the member tree, expand Population and select the member.
  6. Click Apply and Close.
  7. Click Save to save the outline.

See Working with Attributes.