You can set varying attributes for members. Before you set varying attributes, Oracle recommends you set up a history table, as described in Setting Up a History Table for Varying Attributes.
For information on varying attributes and their use, see Varying Attributes Overview.
Note: | Varying attributes are not supported in calendar hierarchies. |
To set a member as a varying attribute:
Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.
In Attribute settings, select the Essbase attribute for (member name) check box.
The name of the dimension in which the member is located is displayed in the Attribute dimension name text box.
By default, varying attributes for members are disabled.
From the drop-down list, select the Attribute type:
Numeric
Boolean
String
Date/Time
Note:
The default attribute type is String.
In the Varying Attribute Settings grouping, click the Edit button.
The Edit Varying Attributes dialog box is displayed.
Keep existing—If there are overlapping ranges for the attribute, the original range will be used to determine the value of the varying attribute.
Overwrite—If there are overlapping ranges for the attribute, the Overwrite option will cause the original range to be overwritten by the later range.
In the Dimension column, select a dimension by selecting the check box next to the left of the dimension name.
Note:
A small white “X” in a red circle will appear in the State column, indicating that there are steps you must complete before the dimension is ready for varying attribute functions. If you hover your cursor over the “X,” a popup message will display the steps still required. If you perform a step that is not needed, the “X” will be replaced by a small, yellow triangle containing an exclamation point.
In the Leaf Level column, highlight the cell for the dimension, and, from the drop-down list, select the member containing the range on which the value of the varying attribute will depend.
Note:
If two independent dimensions have the same leaf member name for one varying attribute, deployment fails.
For example, suppose there is a varying attribute dimension, “VAYRPER,” and two independent dimensions, “Period” and “Year.” If the leaf member name is the same for “Period” and “Year,” the deployment will fail.
To prevent this error, in at least one of the hierarchies representing an independent dimension, rename the dimension element that will be used as the leaf member . Then, retry the deployment.
In the Type column, highlight the cell for the dimension and, from the drop-down list, choose whether the value of the varying attribute is Range or Individual:
Range—the value of the varying attribute will reflect a range of values; for example, the sales representative for a client changes in midyear, so the value of the varying attribute covers January through December.
Individual—the value of the varying attribute will reflect an individual value; for example, the sales representative for a client in Kansas is different from the sales representative for the client in Oklahoma, so the varying attribute covers Oklahoma only.
Note:
The type “Range” should be used for time ranges.
In the From column, click the cell for the dimension and click the
button. Note:
The expression to define an independent dimension binding is written in CPL (Common Platform Language). The expression is a sequence of operands and operators following the language-defined syntax. Each expression returns a value, the type of which defines the type of the expression. See CPL Reference.
The Independent Dimension Binding dialog box is displayed. Here, you will define the binding of the independent dimension and add filters to further refine the definition.
Note:
For ease of use, you can resize the Independent Dimension Binding dialog box.
In the Independent Dimension Binding dialog box, create an expression to define the binding for the dimension:
Note:
For limitations on creating expressions, see Independent Dimension Bindings Limitations
Optional: Create an expression to add filters to further refine the binding definition:
Optional: In the To column, click the cell for the dimension and click the button which appears.
The Independent Dimension Binding dialog box is displayed. Here, you will continue to define the binding of the independent dimension and add filters to refine the binding.
Note:
For ease of use, you may want to expand the Independent Dimension Binding dialog box.