on 08-14-2013 6:43 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.