Migrated content for measure extensibility – Format and edit calculations

Standard demand and inventory measures in the content are migrated to define default formats and edit calculations in the Measure configuration, where applicable. This simplifies the ability to extend measures: one format definition or edit calculation rule for all occurrences.

This feature has been introduced in v20.8, however, the standard templates are migrated for complete utilize. This removes the requirement to define the format or edit calculation parameter in each worksheet, while supporting overrides to the default worksheet format and worksheet edit calculation without having to customize or copy standard measures, or worksheets. Overrides are maintained when appending standard content.

Some measures may not have a format defined if measures have no specific properties outside of the Format on the Details tab (the numeric or date type); or no specific edit calculation rule. For example, measures which are not visible in worksheets, cannot be modified; or require no specific formatting.

All worksheet parameters are maintained for reference, but the parameters are mostly disabled. Therefore, the measure definitions are used, where applicable. The number of worksheets have rv_measure_format parameters enabled where worksheet specific overrides are required for a subset of measures:

• IPLS EOQ Parameters. Measure: DPLS_FCOST.
• DPLS Item Selection. Measure defined in application variable:

  dpls_demand_mgr_selection_measure.

• DPLS Location Selection. Measure defined in application variable:

  dpls_demand_mgr_selection_measure.

• DPLS Outlook Editor. Measures: DPLS_BSELL, DPLS_FSELL, DPLS_FOUTLOOKGAP.
• DPLS Outlook Editor (CM). Measures: DPLS_BSELL, DPLS_FSELL, DPLS_FOUTLOOKGAP.

Formats defined in a worksheet through rv_measure_format that include a measure, takes precedence over that measure's values. This is the order for applying format:

• 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.

Edit calculations defined in a worksheet through rv_measure_calc that include a measure takes precedence over that measure's values. This is the order for applying edit calculation:

• rv_measure_calc override value
• rv_measure_calc default value
• Measure definition Calculation Override value
• Measure definition Default Worksheet calculation value
• rv_measure_spreadlike

Measure configuration is versioned, therefore changes are effective on creation of the next cycle period or with pause and resume with refresh for any related, running cycle periods.