SAP BPC10.1: Nested IF Statement in Transformation file

[Former Member]

Hi Expert

I have following members in ACCOUNT Dimension:

ACCTYPE
BUDGET_INPUT
DIMLIST_FS
ELIMACC
GROUP
INPUTFLOWS
ISINTERCO
RATETYPE
SCALING
SENDTOBUDGET
STYLE
TYPELIM

I wrote following nested IF statement in TRANSFORMATION fie for loading data into FLOW dimension:

FLOW=*IF(ACCTYPE  = *STR(EXP) THEN *STR(F10); ACCTYPE = *STR(INC) THEN *STR(F10);*IF(ACCTYPE  = *STR(AST) THEN *STR(F40);ACCTYPE = *STR(LEQ) THEN *STR(T160);*STR(F99))

Error occurred Field name ACCTYPE does not exist in validation the transformation file as shown in the following screen shot:

I also tried ACCOUNT__ACCTYPE and /CPMB/PWDW398__/CPMB/ACCTYPE but error is till there.

Your guidance is highly appreciated.

Regards

ISKhan

[former_member186338]

Sorry, but again and again! Details required!

What chain is used?

Data sample?

[Former Member]

It's Validate and Process Transformation file of transnational data before using the chain in package.

After knowing that only if we have the property in the 0GL_Account Infoobject, there's no way to access the BPC dimension property through transformation file so I change it the formula as following according to sample data screen shot :

IF 0GL_ACCOUNT__0BAL_FLAG = 'X' STORE F99 ;

IF 0GL_ACCOUNT__0INCST_FLAG = 'XX' STORE F10;

ELSE STORE F99;

  FLOW=*IF(0GL_ACCOUNT__0BAL_FLAG  = *STR(X) THEN
  *STR(F99);0GL_ACCOUNT__0INCST_FLAG = *STR(XX) THEN *STR(F10);*STR(F99))

But same error:

[benniejayfguevarra]

Hi imran.shafiq,

For the InfoObject attributes, there's no need to attached the InfoObject prefix.

 FLOW =*IF(0BAL_FLAG =*STR(X) THEN *STR(F99);
       0INCST_FLAG =*STR(XX) THEN *STR(F10);*STR(F99))

Thanks,

Bennie