Entering Values for a Member Range Variable

A member range variable can be a Planning replacement variable. The member range variable should contain a range of members.

To enter values for a member range variable:

1. From Type, select Member Range.

2. In the Variable grid, perform these steps:

   1. For each dimension in the table for which you want to select limits for the member range, 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.)

      At the global level, if you select the Dimension Type option, only the standard dimension types are shown. If you select the Dimension Names option, you can type in any dimension name.

      Note:

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

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

   2. Enter or use the Member Selector to select default values for the member range, or if the variable is a runtime prompt, you can leave the default value empty. You can select multiple members and functions for each dimension listed.

   3. Select RTP for each dimension listed if you want the variable to prompt users for information when it is launched.

      Note:

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

   4. For each dimension for which you selected RTP, enter the runtime prompt text.

   5. In the RTP text box above the grid, enter the runtime prompt text you want to display for users each time the variable is launched for that dimension.

3. Click .