Difference between Derived Measure and Calculated Measure in SSAS
-
S.No Derived MeasureCalculated Measure1When 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 .
No comments:
Post a Comment