Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers