InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Difference Between A Derived Measure And A Calculated Measure? |
|
Answer» The difference between a derived measure and a CALCULATED measure is when the calculation is performed. A derived measure is calculated before aggregations are created, and the values of the derived measure are stored in the CUBE. A calculated measure is calculated after aggregations are created, and the values of a calculated measure aren’t stored in the cube. The primary CRITERION for CHOOSING between a derived measure and a calculated measure is not efficiency, but accuracy. The difference between a derived measure and a calculated measure is when the calculation is performed. A derived measure is calculated before aggregations are created, and the values of the derived measure are stored in the cube. A calculated measure is calculated after aggregations are created, and the values of a calculated measure aren’t stored in the cube. The primary criterion for choosing between a derived measure and a calculated measure is not efficiency, but accuracy. |
|