Layout and Behavior parameters

This table lists the layout and behavior parameters applicable for the Planning Engine report:
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