cancel
Showing results for 
Search instead for 
Did you mean: 

BPC Transformations - IF Condition

Former Member
0 Kudos

Hi,

We are loading the data from SAP BW to BPC cube.

In one of our transformation, for one of the dimension we need to write a IF condition as follows.

IF item_category <> space, then item_category

ELSE IF cost_element <> space, then cost_element

ELSE 'ZZZZZZ'.

I searched SDN, i came to know we cannot use "not equal to" and "multiple IF conditions" in the transformations.

I cannot manipulate the data in the end routine, because item_category and cost_element exists in source structure but not in target structure.

Is there any way to proceed on this?

Thanks

Srinivas.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Srinivas,

Try this

*IF(item_category+cost_element=item_category then item_category; item_category+cost_element=cost_element then cost_element; item_category+cost_element+*STR(P)=*STR(P) then *STR(ZZZZZZ); item_category+cost_element=item_category+cost_element then item_category)

Regards,

Kalyan.

Former Member
0 Kudos

Hi Kalyan,

Logic worked for me, Thanks for your help.

Srinivas

Answers (0)