12/17/2012
What is the difference between a derived measure and a calculated measure?
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.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment