Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Caching computed measures on row level

Hello,   I have a question regarding the optimization of a measure. Assuming the following situation: Connection to a SSAS cube.   One Measure "Delta" is computed for each row in a table. Now I...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    Since the calculation of measures needs context, I'm afraid "storing the results of a measure" is also expensive. There could be workarounds for each specialized scenario. That is the calculated table. The result of measure will be stored in this scenario.

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Since the calculation of measures needs context, I'm afraid "storing the results of a measure" is also expensive. There could be workarounds for each specialized scenario. That is the calculated table. The result of measure will be stored in this scenario.

 

Best Regards,

Dale