Skip to Content
0

how can I use nested If else in transformation file in SAP BPC?

Jan 23 at 06:50 AM

140

avatar image
Former Member
ZDEP_ID = *IF(ZCOMP_CO = *STR(C_1) THEN *IF(ZDEP_ID = *STR(DEP_1) THEN *STR(DEP_2) ; *STR(TEST)) ; *STR(DEP_5) )

I'm trying like this but getting error while validating the transformation file.

C_1, DEP_1,DEP_2,TEST,DEP_5 all are members of ZDEP_ID and ZCOMP_CO dimension.

This is a test scenario where I'm testing whether nested IF ELSE works in BPC transformation file or not.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers