You define a PageKey range to specify a set of default dimension members to use for the entire data range.
The PageKey range is optional and you can limit it to only specific dimensions in the application.
If any dimensions are not specified in the PageKey range, the system takes them from the current view or the workbook-specific current view. For more information, see Current View.
You can enter one or more members in a PageKey range cell. If you want to enter multiple members, use a comma-separated list. The system adds the values of the set of members you specify for the given dimension. For example, if you specify ENTITY: Rome,Milan,Naples in the PageKey range, all retrieved values for the page contain the sum of the values from Rome, Milan, and Naples.
If the page key has an expansion dimension, the system uses the member ID for the evaluation of the expansion.
You can use the EvMBR function in the PageKey range to define specific members to display the ID of a member (selected from the Member Lookup dialog box) in the cell without changing the current view. See EvMBR.
The PageKey range definition must reference member IDs that exist in a one-column range.
To define the PageKey range, from the Excel interface, open the EvDRE report or input schedule you are building. In the PageKeyRange fields of the Key range parameter table, enter a range of cells that points to one or more dimensions. For information about entering ranges, see EvRNG. Save the report or input schedule.