Layout and Behaviour 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 |