Measure Calculation properties

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.

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.