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:

Select Configuration > Common > Worksheets.
Click New.
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.

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.

Click Save.