Measure extensibility
The advanced format and edit calculation properties can now be specified within the measure definition, as XML. This functionality supports user overrides of the format and edit calculation. Therefore, the format or edit calculation parameter is not required to be specified in each worksheet. Additionally, this feature also supports overrides to the default worksheet format and worksheet edit calculation without customizing or copying standard measures, or worksheets. Overrides are maintained when appending standard content.
The required syntax is XML based on existing rv_measure_format and rv_measure_calc worksheet parameter syntax. Properties that have different requirement from the default values must be defined.
The option clears the field and populates again with XML containing all the relevant properties for the parameter.
Measure formats (if any) defined in a worksheet through rv_measure_format, that include the measure takes precedence over these values. This is the order in which the format is applied:
- rv_measure_format override value
- rv_measure_format default value
- Measure definition Format Override value
- Measure definition Default Worksheet format value
- Basic format defined in the Format field from measure definition Details tab
Measure calculations (if any) defined in a worksheet, through rv_measure_calc, that include the measure takes precedence over these values. This is the order in which the edit calculation is applied:
- rv_measure_calc override value
- rv_measure_calc default value
- Measure definition Calculation Override value
- Measure definition Default Worksheet calculation value
- rv_measure_spreadlike
The new fields are optional, the existing behavior is maintained on upgrade.
By default, this feature is enabled. No additional role or privilege is required to access this feature.