Transformation If statement

[tupai]

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.

Regards

Ani

[ccc_ccc]

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.

http://scn.sap.com/docs/DOC-57719

Regards,

Nanda

[Former Member]

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.

Regards,

AR