9.09.2012

Derived vs Calculated Measure

Difference between Derived Measure and Calculated Measure in SSAS


S.No
Derived Measure
Calculated Measure
1
When it is calculated ?
This is calculated before the aggregation are created .
When it is calculated ?
This is Calculated after aggregations are created .
2
Whether Derived Measure value is stored in Cube or not ?
The values of this measure is stored in the Cube.
Whether Calculated Measure value is stored in Cube or not ?
This values are not stored in the Cube .

1 comment: