Set Attribute Associations

When manually working with attributes, use the outline editor and the Attributes tab in the member inspector, in the Essbase web interface. First associate attribute dimensions with base dimensions, and then 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 Sample.Basic with a base dimension:

  1. Open the outline:

    In the Redwood Interface,

    1. On the Home page, navigate to the application, and select the Actions menu Image of the Actions menu icon in the Redwood interface, on the Applications page, next to the application name..
    2. Choose Databases > Database Name > Launch Outline.
    3. If the outline is locked, and you are an administrator, click Unlock 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 the application.
    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 Image of the Edit outline icon..
  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 Image of the Save outline icon. to save the outline.
  10. In Restructure Database Options, click All Data and click Save.

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 Sample.Basic with a member of a base dimension:
  1. With the Sample.Basic 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.