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.

Read

Top 63 MSBI interview questions and answers for freshers pdf download


Leave a Reply

Your email address will not be published. Required fields are marked *

Name *
Email *
Website