Change Dimension Values of Restricted Measure via Script

[Alexander_Blasl]

Hi,

is there any possible way to change the Dimension Values of a Restricted Measure via Script? The measure should work with a state/condition. When x=1 then (values1-5), When x=2 then (values6-10). In total with 12 different x.

My first thoughts were that I have to create 12 inital Restricted measures with a fixed value selection and then I create a Calculated Measure with 12 IF(). Is that the only way?

[thayumanavan]

Hi @ablasl88,

Did you find the solution for this . Please help me to sort it out. I am also facing the problem.

Change Dimension Values of Restricted Measure via Script

[Alexander_Blasl]

thayu I made 12 restricted measures and 1 caluculated measure with an IF.

My 12 measures represent months. So if you have a dimension with way more members this solution is not very useful.

[saurabh_sonawane · Accepted solution]

Hi

I have to create 12 inital Restricted measures with a fixed value selection and then I create a Calculated Measure with 12 IF(). Is that the only way?

- Yes this is the only way we can achieve the above requirement.

Thanks,

Saurabh S.

[former_member590090]

did you find a answer to this? if so, can you please include a sample code?

[Alexander_Blasl]

No sorry. I did it with 12 initial restr. measures.