You use the Associations tab to associate attributes with base-dimension members that are assigned one of the following data-storage properties: store data, Dynamic Calc, or Dynamic Calc and Store.
The tab provides the following boxes:
Associated attributes—The attributes associated with the current base-dimension member
Available attributes—The attribute dimensions associated with the current base dimension. You expand dimension nodes to view attributes available for assignment.
Full name of selected available attribute—The member name of the attribute selected in the “Available attributes” list, including the prefix or suffix and the joining characters _, ^, or |
To assign or unassign attributes to the current base-dimension member, you click the following buttons:
Assign—To assign the attribute selected in the “Available attributes” box
Remove—To unassign the member selected in the “Associated attributes” box
Remove All—To unassign all attributes listed in the “Attributes associated” box (The button becomes available when you select an attribute that is listed in the “Attributes associated” box.)
Attribute associations must follow these rules:
Associate only level 0 members of attribute dimensions with members of base dimensions.
The base dimension members with which you associate members from a specific attribute dimension must be at the same level.
A member of a base dimension can have only one attribute from each attribute dimension associated with it. For example, product 100-10 can have only one size.
Members from more than one attribute dimension can be associated with one member of a base dimension. For example, product 100-10 can have both a size attribute and a packaging type attribute.
Note: | For information about attribute associations with aggregate storage databases, see the Oracle Essbase Database Administrator's Guide. |