Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Transformation If statement

Hi Experts,

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

RegionProductSale
USAABC10
DEF7
XYZ40
EUROPEDEF5
XYZ6
ASIAABC13
DEF17
XYZ50

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.

Regards

Ani

Former Member
Not what you were looking for? View more on this topic or Ask a question