Varying attributes associate a base dimension with an attribute dimension by associating specific members of the attribute dimension.
To add a varying attribute at a dimension level:
Optional: If necessary, enable the outline for varying attributes. See Enabling Varying Attributes.
In the Member Properties dialog box, select the Attributes tab.
Any attribute dimensions already associated with the base dimension are displayed in the Associated attribute dimensions text box. Other dimensions not yet associated with the base dimension are displayed in the Other attribute dimensions text box. Independent dimensions are displayed in the Independent Dimensions text box.
If the dimension to which you want to add a varying attribute is not yet associated with the base dimension, highlight the dimension in the Other attribute dimensions and click the Assign button.
In the Independent dimensions text box, check the box next to the independent dimension you want to use as a varying attribute.
Note: | You can use the up and down arrow buttons to alter the order of independent dimensions. |
Select the type of independent dimension, Continuous or Discrete.
Note: | There are two types of independent dimensions: continuous and discrete. The members in a continuous dimension reflect continuity. For example, week, month, and quarter reflect the continuity in a time dimension. The members in a discrete dimension do not imply continuity. For example, California, Texas, and Ohio in a market dimension do not have a relationship based on continuity. |
In the Outline tab of the Outline Editor, the independent dimension is now displayed in bold font.
In the Member Properties dialog box, select the Associations tab.
In the Available attributes text box, select the attribute dimension you want to use for the varying attribute.
Optional—Assign a range to the varying attribute by clicking the Add range button.
In the Association mode dialog box, select the appropriate response.
When you reopen your member properties, the newly added varying attribute is displayed.