Using Delayed Key Bindings in Hierarchies

The key binding in a hierarchy reflects the key binding from the metadata element. You can use a delayed key binding in a hierarchy.

You can choose to define the delayed binding or elect to have Essbase Studio generate the delayed binding. If you choose to define the key binding for a delayed element, the key binding will only be saved with that hierarchy. The key binding will not update the original metadata element.

To use the key binding column in a hierarchy:

Create a dimension element, using the Delayed key binding option (see step 3).
Right-click the appropriate folder in the Metadata Navigator and select New, and then Hierarchy to launch the hierarchy editor.
Enter the Name for the hierarchy.
The default name is NewHierarchy.
Optional—Enter a Description.
Drag-and-drop from the Metadata Navigator:
1. In the Metadata Navigator, navigate to the location of the applicable dimension element.
2. Select the dimension element, drag it to the Edit Hierarchy dialog box, and drop it under the Hierarchy column in the Data group.
  The text for Key Binding will be “Delayed”.
  Note:
  If you save the hierarchy at this step in the procedure, the text “Delayed” in the Key Binding column will be replaced by a binding generated by Essbase Studio.
In the Key Binding column, click the cell for the dimension element and click the button.
The Edit Entity dialog box is displayed.

Create an expression to define the delayed binding:

Note:

The expression to define a delayed key 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.

Select the Source tab in the lower-left of the dialog box.
Expand the dimensions to display the members.
Select a member.
Drag or double-click the member to move the connection string for the member to the Expression text box.
Select the Functions tab.
Expand the SQL level to display the function types.
Expand the function types to display the functions.
Select a function.
Drag or double-click the function string to move it to the Expression text box.
Select the Operators tab.
Expand the operator types to display the operators.
Select an operator.
Drag or double-click the operator to move it to the Expression text box.

Optional: Create an expression to add filters to further refine the delayed binding definition:
1. Select the Source tab in the lower-left of the dialog box.
2. Expand the dimensions to display the members.
3. Select a member.
4. Drag or double-click the member to move the connection string for the member to the Expression text box.
5. Select the Functions tab.
6. Expand the SQL level to display the function types.
7. Expand the function types to display the functions.
8. Select a function.
9. Drag or double-click the function string to move it to the Expression text box.
10. Select the Operators tab.
11. Expand the operator types to display the operators.
12. Select an operator.
13. Drag or double-click the operator to move it to the Expression text box.
Click OK.
The Key Binding column will display the binding definition you just created.
Click Save.
Note:
If you save the hierarchy at this step in the procedure, the Key Binding column will become the binding definition you just created.