To move the calculations in Master measures to data load editor

[Koti_Ch]

Hi,

I have a bunch of Master measures that I use for my application. Now to improve the performance of the app, I'm trying to move the calculations to the backend. But the master measures have a lot of calculations in them including set analysis. Can you assist with any approach of how to do this..?

Thanks in advance

Koteswar

[AG-gugelbisolutions]

I don't think there is any easy and straightforward solution, I'm afraid.

However, as a general rule of thumb, you could, for example, translate if and set-analysis to flags so that your measures get at least simpler.

Could you provide us with an example? 

[AG-gugelbisolutions]

I'm afraid you cannot bring to the script this kind of conditions. The point is that the result depends on current selections.

What you could try in order to optimize performance is to put the "count(...)=1 and count(...)>=1" condition in a variable with the = sign at the beginning, but it will work only if this condition is used all over the places in th application. 

[Koti_Ch]

Thank you.