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:
   1. On the Home page, navigate to the application, and select the Actions menu .
   2. Choose Databases > Database Name > Launch Outline.
   3. If the outline is locked, and you are an administrator, click Unlock .

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

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.
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. Select the down arrow in the Population row and select the member.
6. Click Apply and Close.
7. Click Save to save the outline.

See Working with Attributes.