Skip to Content

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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 30, 2014 at 07:28 PM

    Hello Ani,

    What you are looking for is to add an extra field in cube which will suggest Expand or Close. This feild will be calculated during the DTP run. Then you can publish the field value in report.

    You can go for a formula if you do not want to write a routine.



    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2014 at 07:43 PM

    Hi Ani,

    We have two options.

    1 Write start routine to determine Expand or Close, but this option is not recommended because data might change so in result might not be correct all the time.

    2 Implement virtual characteristic concept it will calculate at runtime, so that result will be correct.



    Add comment
    10|10000 characters needed characters exceeded