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