Layout and Behavior parameters

Field	Name	Default	Description
rv_left_dim	Left dimensions (rows)	R	The Left dimensions on the pivot report that must be displayed in the rows. The values can be R, Pr, P, and are separated by a comma. The specified dimensions in the “left” dimension cannot be displayed in the "top" dimension variable; that is, each dimension parameter value must be unique. If not defined, Resources (R) set as default
rv_top_dim	Top dimensions (columns)	P, Pr	The Top dimensions on the pivot report, that must be displayed in the columns. The values can be any of R,P, Pr, and with each dimension is separated by a comma. The specified dimensions cannot be displayed in the "left" dimension variable; that is, each dimension parameter value must be unique. If not defined, Property (P, Pr) set as defaults to Periods.
rv_column_width	Column Widths	90	Specifies the width of columns (in pixels) for the plansheet. Specified in the format - data_cell_width:dimension_cell_width1 to N [data_cell_width : left_dim1_width : left_dim2_width : …:left_dimN_width] For example, 80:90:180 represents 80px for the data columns, 90 for left1 dimension, 180 for left2 dimension. A value of 90 is 90px for data columns and the default width for any dimension columns
rv_slicers_hide	Hide Slicers	None	A comma-separated list of dimensions that must be included in the slicers area of the plansheet. By default, all dimensions are displayed in the slicers area. however, the user can define some dimensions that must not be displayed, if not applicable to the plansheet or to prevent change of the selection from the plansheet. It hides those specified dimensions from the slicer. In this case, the default element is passed to the plansheet but the dimension & element are hidden in the slicer area. For example, P,RA2: hide periods, and resource attribute 2 from the slicers area. Default = False, all dimensions are displayed, if not defined. If rv_pivot_hide = FALSE then the slicer area is displayed in the pivot, if rv_pivot_hide = TRUE then the slicer area is displayed in the chart area.
rv_sort_property	Sort Property	None	The property name to which the sort is applied. If this parameter is not specified, the sorting is not applied. Note: This parameter is applicable only if the rv_sort_period property is specified, and properties and periods are displayed in columns, or in slicer. A single property must be specified to apply sort. The property must be applicable to the resources displayed in the plansheet. The property must be an atomic property. The specified property must be displayed on the grid or in the slicer.
rv_sort_period	Sort Period	None	The period name to which the sort is applied. Note: This parameter is applicable only if the rv_sort_property parameter is defined, and properties and periods are displayed in columns, or in slicer. A single period must be specified to apply sort. If the value is not specified or invalid, the sorting is not applied. The parameter can be populated with application variable, specific period (For example, FY24 W24), or period index (For example, [#3]). The specified period must be displayed on the grid or in the slicer.
rv_sort_direction	Sort direction	DESC	The direction in which the sort is applied. If this parameter is not specified, or invalid, the value is set to Desc (Display largest to smallest value). Acceptable values, ASC or DESC (case insensitive). Note: This parameter is applicable only if the rv_sort_property and rv_sort_period parameters are specified, and periods and properties are displayed in columns or in slicer.
rv_top_results	Top Results	None	The number of results to display. If the parameter value is not specified or invalid, all results are displayed. Note: This parameter is applicable only if the rv_sort_property and rv_sort_period parameters are specified, and periods and properties are displayed in columns or in slicer.
rv_macro1_button	Execute Macro button	None	The name of macro that can be executed directly via a button from the plansheet toolbar. If defined, the tooltip displays the macro name. If not defined, no button is displayed. This supports all macro types.
rv_macro1_button
rv_macro2_button
rv_macro3_button
rv_macro4_button
rv_macro5_button
rv_Workflow1_button	Execute Workflow button	None	The name of workflow that can be directly executed via a button from the plansheet toolbar. This parameter expects a valid Planning Engine workflow as the parameter value. The button displays the Save and Run Workflow X option, where X is the workflow display name (if defined, else, workflow name is displayed). If not defined or worfklow cannot be found, no button is displayed.
rv_Workflow2_button
rv_Workflow3_button
rv_Workflow4_button
rv_Workflow5_button

rv_left_dim

Left dimensions (rows)

R

The Left dimensions on the pivot report that must be displayed in the rows. The values can be R, Pr, P, and are separated by a comma. The specified dimensions in the “left” dimension cannot be displayed in the "top" dimension variable; that is, each dimension parameter value must be unique. If not defined, Resources (R) set as default

rv_top_dim

Top dimensions (columns)

P, Pr

The Top dimensions on the pivot report, that must be displayed in the columns. The values can be any of R,P, Pr, and with each dimension is separated by a comma. The specified dimensions cannot be displayed in the "left" dimension variable; that is, each dimension parameter value must be unique. If not defined, Property (P, Pr) set as defaults to Periods.

rv_column_width

Column Widths

90

Specifies the width of columns (in pixels) for the plansheet. Specified in the format - data_cell_width:dimension_cell_width1 to N [data_cell_width : left_dim1_width : left_dim2_width : …:left_dimN_width]

For example, 80:90:180 represents 80px for the data columns, 90 for left1 dimension, 180 for left2 dimension. A value of 90 is 90px for data columns and the default width for any dimension columns

rv_slicers_hide

Hide Slicers

None

A comma-separated list of dimensions that must be included in the slicers area of the plansheet. By default, all dimensions are displayed in the slicers area. however, the user can define some dimensions that must not be displayed, if not applicable to the plansheet or to prevent change of the selection from the plansheet. It hides those specified dimensions from the slicer. In this case, the default element is passed to the plansheet but the dimension & element are hidden in the slicer area. For example, P,RA2: hide periods, and resource attribute 2 from the slicers area. Default = False, all dimensions are displayed, if not defined. If rv_pivot_hide = FALSE then the slicer area is displayed in the pivot, if rv_pivot_hide = TRUE then the slicer area is displayed in the chart area.

rv_sort_property

Sort Property

None

The property name to which the sort is applied. If this parameter is not specified, the sorting is not applied.

Note:

This parameter is applicable only if the rv_sort_period property is specified, and properties and periods are displayed in columns, or in slicer.
A single property must be specified to apply sort. The property must be applicable to the resources displayed in the plansheet.
The property must be an atomic property.
The specified property must be displayed on the grid or in the slicer.

rv_sort_period

Sort Period

None

The period name to which the sort is applied.

Note:

This parameter is applicable only if the rv_sort_property parameter is defined, and properties and periods are displayed in columns, or in slicer.
A single period must be specified to apply sort. If the value is not specified or invalid, the sorting is not applied.
The parameter can be populated with application variable, specific period (For example, FY24 W24), or period index (For example, [#3]).
The specified period must be displayed on the grid or in the slicer.

rv_sort_direction

Sort direction

DESC

The direction in which the sort is applied. If this parameter is not specified, or invalid, the value is set to Desc (Display largest to smallest value). Acceptable values, ASC or DESC (case insensitive).

Note: This parameter is applicable only if the rv_sort_property and rv_sort_period parameters are specified, and periods and properties are displayed in columns or in slicer.

rv_top_results