Worksheet extensibility – Parameter overrides

This enhancement aims at simplifying implementation extensions and content upgrades. Additionally, this enhancement also supports modifying the behavior of a worksheet by defining parameter override values without customizing or replicating the standard worksheets. A typical use case can be used to add a customer-specific measure to the list of default measures for a worksheet; or to hide measures that are not applicable.

The syntax of the Override Value field based on the Default Value for the corresponding parameter. Overrides are maintained when appending standard content.

The Default Value cannot be specified for new parameters for worksheet's where System=True and cannot be modified for existing parameters.

The worksheet parameter Override Value field supports these new variables:

• %default% can be used to extend the default value and add extra values
• %empty% can be used to override the default value with no value

%default% supports extending the parameter while picking up the changes to the Default Value, in future content updates.

The resulting syntax must be in the correct format for the worksheet parameter. It is not possible to create valid formats for all worksheet parameters using %default% due to complex syntax in some cases, that is %default% with rv_measure_format or rv_measure_calc parameter is not supported.

By default, this feature is enabled. No additional role or privilege is required to access this feature.