Measure parameters

This table lists the measure parameters applicable for the Pivot Editor report:

Field	Name	Default	Description
rv_measure_passed	Measures	None	Used to display the list of measures in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} must be specified.
rv_measure_calc	Measures Edit Calculations	None	An XML table of rules for editing 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. See, Measure Calculation properties.
rv_measure_editable	Editable Measures	rv_measure_passed	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 cannot be modified, any empty set {} is passed.
rv_measure_except	Measures Hidden on Pivot	None	The list of measures that are not displayed on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_measure_passed parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports MDX definition for the set. If not defined, all the measures specified in the rv_measure_passed parameter are displayed.
rv_measure_format	Measures Format	None	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. See, Measure Format properties.
rv_measure_spreadlike	Measures Spread Like	Cycle.Period Spread 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.