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_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_macro2_button
rv_macro3_button
rv_macro4_button
rv_macro5_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_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_macro2_button

rv_macro3_button

rv_macro4_button

rv_macro5_button