Skip to Content
Dec 30, 2014 at 12:28 PM

Transformation If statement


Hi Experts,

Need some Modelling tips. I am getting data in the cube as below:

Region Product Sale USA ABC 10 DEF 7 XYZ 40 EUROPE DEF 5 XYZ 6 ASIA ABC 13 DEF 17 XYZ 50

I am required to add a new data in the report with logic :

If for perticular 'Region' all product sale is =< 10 then 'Expand' else 'Close'. That is for the perticular region if any of the product have sale below 10 then 'Close' for entier region. Please suggest how can I achive this with transformation (not involving any routine). I understand I cannot handle this at query level as I cannot update the word 'Expand' or 'Close' using query designer.