Measure Calculation properties

This table lists the properties used for measure calculation:
Property Description
targetmeasure The measure used to receive the edited value.
weightmeasure_multiply The measure used to multiply the edited difference (between the original and the new value).
weightmeasure_divide The measure used to divide the edited difference (between the old and the new value).
measure_spread The measure used to spread the weighted difference.
spread_type Either 'delta' or 'value'. Indicates the spreading method to be used with the measure_spread; wherein 'value' is the new value and 'delta' is the edited difference between the existing value and the new value. Applicable when the previous value is not null otherwise, the behavior of the Delta and Value is the same, when existing value is 0 or #NA. Uses 'delta' if not specified. If not defined, you can edit the measure values; based on the calculated cells. The edits are rejected by OLAP.
spread_rounding The number of digits that can be used to round off the spread result. 0 = spread as an integer value. If spread_rounding is defined as a positive integer, the splash command is used with rounding. If not defined, or negative, the rounding is disabled. If “measure_spread” is null, the ifemptyspreadmeasure_spread_rounding parameter is applied.
spread_error_correction Can be set to TRUE or FALSE. If TRUE or undefined error correction is applied on the spread result, that is, one base element can receive a rounded value to ensure the sum of all spread results equals the (aggregate) splashed value. FALSE: No error correction.
ifemptymeasurespread_targetmeasure Used to specify the target measure that must be used if the measure_spread is null.
ifemptymeasurespread_weightmeasure_multiply Used to specify the measure that must be used to multiply the values, if the measure_spread is null.
ifemptymeasurespread_weightmeasure_divide Used to specify the measure that must be used to divide the values, if the measure_spread is null.
ifemptymeasurespread_measure_spread The measure that must be used to spread the values, if the measure_spread is null.
Ifemptymeasurespread_spread_rounding Used to specify the number of digits that can be used to round off the spread result, if measure_spread is null, undefined, or negative).
Ifemptymeasurespread_spread_error_correction Specify TRUE or FALSE to apply error correction, if measure_spread is null (default TRUE, if undefined). If not defined, you cannot edit measure values based on calculated cells; and the edits are rejected by OLAP.