Worksheet parameter preferences

The application uses the following priority to load the parameters defined in standard and multipanel worksheet:
  • Worksheet parameter:
    1. MultiPanel parameter (override)
    2. MultiPanel parameter (default)
    3. Standard Worksheet parameter (override)
    4. Standard Worksheet parameter (default)
    5. Module data context (used for scenario, item, period or location related parameters)
    6. Default value of the parameter
    Note: The default settings for rv_measure_calc and rv_measure_format parameters are determined by the individual measure definitions:
    • Measure definition - Default Worksheet Calculation or Calculation Override (if populated)
    • Measure definition - Default Worksheet Format or Format Override (if populated)
  • Panel linking:
    1. MultiPanel parameter (override)
    2. MultiPanel parameter (default)
    3. Pass dimension field
    4. Standard parameter (override)
    5. Standard parameter (default)
    6. Module data context
    7. Default value of the parameter