xtrRollupTiming Value List

Determines when calculations are performed for calculated measures.

Applies To

Discussion

Use the constants of this value list with the RollupTiming property of the Measure object. The constants determine when rollups for measures occur in relation to calculations involving those measures. The MeasureType property of the Measure object must be set to trCalculatedMeasure.

Constant	Description
trTimingAfterRollup	Specifies that calculated measures are based on the rolled up values. The sequence is: 1 Regular rollup takes place on all measures. 2 Time state rollup takes place. 3 Allocated measures are calculated. 4 Calculations are performed on calculated measures.
trTimingBeforeRollup	Specifies that calculated measures are based on original source values. The sequence is: 1 Calculations are performed as the cube is created. 2 Regular rollup takes place on all measures. 3 Time state rollup takes place. 4 Allocated measures are calculated.
trTimingDefault	Specifies that trTimingAfterRollup is used.

Constant

Description

trTimingAfterRollup

Specifies that calculated measures are based on the rolled up values. The sequence is:

1 Regular rollup takes place on all measures.

2 Time state rollup takes place.

3 Allocated measures are calculated.

4 Calculations are performed on calculated measures.

trTimingBeforeRollup

Specifies that calculated measures are based on original source values. The sequence is:

1 Calculations are performed as the cube is created.

2 Regular rollup takes place on all measures.

3 Time state rollup takes place.

4 Allocated measures are calculated.

trTimingDefault

Specifies that trTimingAfterRollup is used.