Entering Variable Values for a Cross Dimension Variable

A cross dimension variable is a Planning replacement variable. It contains a member from multiple dimensions that enables you to launch business rules across dimensions.

To enter values for a cross dimension variable:

1. From Type, select Cross Dimension.
2. Optional: For each dimension in the table for which you want to select limits for the variable, click in the limit field and enter a limit. (The dimensions that display are the dimensions that belong to the application for which you are creating the variable.)

   Note:

   • You must select RTP before you enter text in the Limits field.

   • When using a function for the Limit, Planning functions are recommended instead of Oracle Essbase functions. In some cases, Essbase functions do not return the expected members; for example, when the evaluation of the Essbase function includes dynamic members. For the Limit in a cross dimension variable, use "ILvl0Descendants("Mbr Name") " instead of the Essbase function "@Relative("Mbr Name", 0)".

   • You can use a function, but the function must return a single member from the dimension to be a valid selection.

3. Enter or use the Member Selector to select a value for the variable. You can select a member or a function.
4. Enter the runtime prompt text.
5. Click .