Entering Variable Values for a Member or Members Variable

The member and members variables are Planning replacement variables. These variables contain a member or multiple members from a dimension that you select.

To enter values for a member or members variable:

  1. From Type, select Member or Members.
  2. In the Variable Grid, select a dimension. The dimension that displays is the dimension that belongs to the application for which you are creating the variable.
  3. Enter or use the Member Selector to select limits for the variable. You can select members only from the dimension you select in step 2. You can also select functions. See Working with Functions.

    Note:

    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 Member or Members variable, use "ILvl0Descendants("Mbr Name") " instead of the Essbase function "@Relative("Mbr Name", 0)".

  4. Enter or use the Member Selector to select a default value for the variable. You can select one member or function for a member variable and multiple members and functions for a members variable.
  5. By default, RTP is selected. If you do not want to create a runtime prompt variable, clear RTP.

    Note:

    If you do not select RTP, you must enter a value for the variable.

  6. If you selected RTP, enter the runtime prompt text you want to display for users.
  7. Select File, and then Save.