none
Calculated measure vs. Query scope measure

    Question

  • Hi,

    We developed in-house application for querying our cube.

    I created lots of calculated measures inside the cube and currently we would like to drop the measures that were defined in the cube and create them on the fly. Meaning to create each calculated measure with the WITH statement when the query is executed. 

    I did some test with few measures to make sure we don't hurt performance and it's seems to be ok.

    I looked for some reference in order to approve that there isn't going to be any  bad performance after we would do this change.

    Do you have any idea what is the difference between creating calculated measure inside the cube vs. creating query scope measure?

    Thanks,

    Liran

    • Changed type liranbn Tuesday, July 31, 2012 10:43 AM
    Tuesday, July 31, 2012 9:55 AM

Answers