Monday, February 6, 2012

“Derived Measure” Vs. “Calculated Measure”

The Main difference between “Derived Measure” and “Calculated Measure” is when the calculation is performed. The following tables will help you understand about this.
Derived Measure
Calculated Measure
This is calculated before the aggregation are created
This is Calculated after aggregations are created
The values of this measure is stored in the Cube
This values aren’t stored in the Cube

You can choose any one the measure depends on your requirements. The main purpose for choosing between a derived measure and a calculated measure is not efficiency, but accuracy.

No comments:

Post a Comment