Difference between Derived Measure and Calculated Measure in SSAS
S.NoDerived MeasureCalculated Measure1When it is calculated ?
This is calculated before the aggregation are created .When it is calculated ?
This is Calculated after aggregations are created .
2Whether 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 .