Load trans data from BW Multiple key figures to BPC Model

[BalaValluru]

Hi Experts,

I am trying to load the transaction data from BW to BPC model.

BW: Having 3 key figures : Acq value, Accum Dep, Ord Dep.

BPC: Signeddata. I am trying to use MVAL function in Transformation file.

SIGNEDDATA=*MVAL(SIGNEDDATA|0ACQ_VAL_TR||SIGNEDDATA|0COR_DEP_PE||SIGNEDDATA|0ORD_DEP_TR)

Error after validation

Could you please help how to load multiple keyfigures to BPC

Thanks

Kishore V

[former_member186338]

The only way to load data according to your requirements is to load 3 times with 3 transformation files...

[BalaValluru]

vadim.kalinin

Can we write the if condition for Account dimension in Transformation file and not disturbing MVAL function. ( From BW same GL account having the data for Acq value and Acc dep from BW .)

Please find the BW cube data.

Thanks

[former_member186338]

What do you mean by IF condition for account???

In IF condition for account you can somehow replace one account with another... but nothing else

[former_member186338]

Sorry, but I do not understand the logic completely...

But anyway, MVAL can't be combined with IF

With MVAL you can load different keyfigures to different members of some dimension. But you can't use IF inside MVAL.

Please show data sample of BW cube with data to load...

[BalaValluru]

vadim.kalinin

Have created 3 members in UOM Dimension. Getting error

UOM=*MVAL(0ACQ_VAL_TR|*NEWCOL(ACQ_VAL)||0COR_DEP_PE|*NEWCOL(ACC_DEP))||0ORD_DEP_TR|*NEWCOL(ORD_DEP))

[former_member186338]

Sorry, but you are not providing full info... Not possible to help without understanding what you are loading...

[former_member186338]

Sorry, but you line is meaningless:

SIGNEDDATA=*MVAL(SIGNEDDATA|0ACQ_VAL_TR||SIGNEDDATA|0COR_DEP_PE||SIGNEDDATA|0ORD_DEP_TR)

Please read help: https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.34/en-US/f9c4554f6faf1014878bae8cb...

=*MVAL(keyfiguretype1|dim_mem1||keyfiguretype2|dim_mem2||keyfiguretype3|dim_mem3)