Transformation File : MVAL with IF Statement

[Former Member]

Hi Team,

I have a requirement where we need to load data from BW Cube to BPC. There are multiple key Figures which are mapped to account ID in BPC through MVAL statement.

Now the user wants to filter one of the key figures based on another column say Y in BW to seperate account ID in BPC.

Tried using MVAL with IF Statement the Error states Validation with Data File failed

[former_member186338]

It's not possible to use IF and MVAL in the same line - no way!

But you can always create a routine badi to do what you want.

[Former Member]

Hi Vadim,

I have attached the sample for the TF

My original TF File with the following Mapping is working

ACCOUNT= *MVAL(ZVV110|*NEWCOL(S0200)||ZVV102|*NEWCOL(S0148)||ZVV103|*NEWCOL(S0207)||ZVV139|*NEWCOL(S0093)||ZVV113|*NEWCOL(S0159))

However I want to use IF Statement here with MVAL refer below the sample mapping. This is not getting validated . The probable reason can be it is unable to understand MVAL and IF Statement Respectively

ACCOUNT=*IF(0DISTR_CHAN = *str(30) then *MVAL(ZVV110|*NEWCOL(S0200)||ZVV102|*NEWCOL(S0148)||ZVV103|*NEWCOL(S0207)||ZVV139|*NEWCOL(S0093)||ZVV113|*NEWCOL(S0159)); *MVAL(ZVV110|*NEWCOL(S0006)||ZVV102|*NEWCOL(S0148)||ZVV103|*NEWCOL(S0207)||ZVV139|*NEWCOL(S0093)||ZVV113|*NEWCOL(S0159)))

tf-sample.txt

[Former Member]

Hi Vadim this link is for the question raised by some other person

[former_member186338]

My mistake! Sorry!

[former_member186338]

P.S. Please provide full info including working transformation file and data sample in BW

[former_member186338]

Please first finish with your first question (https://answers.sap.com/questions/675094/how-to-invoke-nested-logic-script-in-package.html), then I will answer this one!