Scenario Values report

You can configure a standard worksheet, with the ReportSource of the type Embedded, based on the Scenario Values report.

To configure the worksheet based on the Scenario Values report:

  1. Select Configuration > Common > Worksheets.
  2. Click New.
  3. Select Standard Worksheet. Specify this information:
    Name
    Specify the name of the worksheet.
    Display Name
    Specify the name to be displayed in the application. This is an optional field.
    Type
    The type of the worksheet.
    ReportSource
    The source of the report, based on which the worksheet is configured. Select Embedded.
    Report
    The type of the report. Select Scenario Values.
    Users

    Specify the individual users who will have access to the worksheet.

    Available Offline
    If this option is set to On, you can access the worksheet offline, using the Infor Excel Add-in.
    Note: This option is enabled only if you set the Report Source to Embedded.
    System
    If this option is set to On, the worksheet is system-defined.
    Enabled
    If this is set to On, you can view the worksheet in the specified module.
    Module
    The module containing the worksheet. For example, Finance.
    Workbook

    Specify the workbook group to be used, when listing the worksheets for this module. Workbooks are displayed in the dynamic menu of a module's Viewing worksheets page.

    Tags
    Select the tags for the worksheets. These are used to group common configuration elements such as calculation rules or measures.
    Roles

    Specify the list of roles authorized to access the worksheet.

    Note: The role is defaulted to the current user, if user and roles are not selected.
  4. To pass the additional parameters or data to the report, on the Data Parameters tab, specify this information:
    Parameter
    Select the parameters. These are the fixed set of parameters available when the report type is set to Scenario Values:
    Field Name Mandatory Description
    rv_measure_passed Measures Yes The list of measures that can be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]}. If the measures cannot be derived, data is not displayed in the worksheet.
    Note: This is a mandatory parameter.
    rv_column_per_measure Column per measure No If value specified is 'false' the report displays each measure on a new row for each item, location, and period combination. By default, this parameter is set to False. The value column is a fixed five column report; if 'true', the report displays each measure on a new column for each item, location, and period combination. The scenario values for each specified measure is displayed in a separate column.
    rv_column_width Column Widths No Specifies the width of columns (in pixels) for the filtered report. Specified in the format: data_cell_width[:left_dim1_width:left_dim2_width:…:left_dimN_width] (left1, left2 dim only initially). For example, 80:90:180 represents 80px for the data columns, 90 for the left1 dimension, and 180 for the left2 dimension. A value of 90 is 90px for the data columns and the default width for any dimension columns.
    rv_item_passed Items passed No A single element [element1] or a set in the form: {[element1],[element2]} must be defined. Overrides the main item data context (for the module) for this worksheet.
    rv_location_passed Locations passed No A single element [element1] or a set in the form: {[element1],[element2]} must be defined. Overrides the main location data context (for the module) for this worksheet.
    rv_period_passed Periods passed No A single element [element1] or a set in the form: {[element1],[element2]} must be defined. Overrides the main period data context (for the module) for this worksheet.
    rv_measure_calc Measures Edit Calculations No An XML table of rules, to edit the calculated measures in the worksheet. Each measure calculation exists as a row and the name of the measure code is specified. Each property is defined as a name and value pair.

    Properties:

    • targetmeasure: The measure used to receive the edited value.
    • weightmeasure_multiply: The measure used to multiply the edited difference (between the original and the new value).
    • weightmeasure_divide: The measure used to divide the edited difference (between the old and the new value).
    • measure_spread: The measure used to spread the weighted difference.
    • spread_type: Either 'delta' or 'value'. Indicates the spreading method to be used with the measure_spread; wherein 'value' is the new value and 'delta' is the edited difference between the existing value and the new value. Applicable when the previous value is not null otherwise, the behavior of the Delta and Value is the same, when existing value is 0 or #NA. Uses 'delta' if not specified. If not defined, you can edit the measure values; based on the calculated cells. The edits are rejected by OLAP.
    rv_measure_editable Editable Measures No The list of editable measures in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. If not set, by default, all measures can be edited. To ensure that all measures in the worksheet are read-only, an empty set {} is passed.
    rv_measure_format Measures Format No An XML table of the format and color coding for the measures, defined in the worksheet. Each measure format exists as a row and the name of the measure code is specified. Each property is defined as a name and value pair.

    Properties:

    • format: The format for the measure values. The valid format values are "0", "0.00", "0%", "0.00%", "Date","Datetime", "KPI".
    • highamber: Sets the background to amber when the scenario values >= the value for the corresponding measure.
    • highred: Sets the background to red when the scenario values >= the value for the corresponding measure.
    • lowamber: Sets the background to amber when the scenario values <= the value for the corresponding measure.
    • lowred: Sets the background to red when the scenario values <= the value for the corresponding measure.
    • highlightgreen: If TRUE, sets the background to green when scenario values are within the amber and red conditions, otherwise displays the normal (white) background color. Applicable where the measure has at least one highamber, or highred, or lowamber, or lowred defined.
    • size: Used when format = KPI, allows the user to set the KPI indicators to a certain size. Valid size values are 'equal' or 'proportional'.
    • type: Used in conjunction with size, if the type is set to equal, the same can be set to either 'blob' or 'icon', if the type is set to proportional, the same can only be set to 'blob'.
    • total: If TRUE, sets the values to bold. If measure is not defined on the pivot, this condition is ignored.
    • insertblank: If TRUE, a blank row (if measure is on Left Dim) or blank column (if measure is on Top Dim) is inserted, in the worksheet after the selected measure. If the measure is not defined on the pivot, the same is ignored
    rv_measure_spreadlike Measures Spread Like No The measure used by default, when spreading the new values (cells = 0) to the base level elements. A single element [element1] is required. If no value is passed, the default period spread measure is used.
    rv_period_lock Periods Edit Lock No The list of periods that are locked for editing. The ascendants or descendants of the periods are also locked. This is a subset of the rv_period_passed parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. For example, rv_period_lock = [FY 14 Qtr1] locks the Ascendants: FY 2014 and "Monthly Calendar" (calendar name / aggregate). Descendants: FY14 M01, FY14 M02, FY14 M03. If not defined, all the elements in the rv_period_passed parameter, can be edited.
    rv_period_passed Period Passed No A single element [element1] or a set in the form: {[element1],[element2]} must be defined. Overrides the main period data context (for the module) for this worksheet.
    Description
    Specify a description.
    Value
    Specify the data value to be passed to the report when the report is viewed.
    Enabled
    If this check box is selected, the parameter is used in the worksheet.
  5. Click Save.