Enter Values for a Member Range Variable

A member range variable can be an Essbase replacement variable. The member range variable should contain a range of members inclusive of, and between, two specified members.

Entering Values for a Member Range Variable

To enter values for a member range variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. In the Variable Navigator, expand the Essbase application type.

  5. From Type, select Member Range.

  6. In the Value table, do the following: is you are creating a member range for Essbase.

    1. If you are creating a member range variable for Essbase:

      1. For each dimension for which you want to define a member range, enter or use the Member Selector to select limits for the member range. (The dimensions that display are the dimensions that belong to the application for which you are creating the variable.)

      2. Enter or use the Member Selector to select values for the member range. You can select multiple members and functions for each dimension listed.

  7. Select File, Save.