MVAL in SAP BPC 10.1 NW

[srshekars]

Hi,

We have a requirement to bring QTY to BPC along with 0Amount. created a MVAL in Transformation File and it is validated successfully but triggers error saying "Mapping Table can only contain one *MVAL". We already used MVAL function for another Mapping. Is this causing the issue. How to handle this MVAL. Below is the Transformation File.

SAP Business Planning and Consolidation, version for SAP NetWeaver 

Thanks

Sekhar SR

[benniejayfguevarra]

Hi Sekhar,

The answer is already in the error message. You cannot use multiple MVALs.

Thanks,

Bennie

[benniejayfguevarra]

There are many ways use it in 1 dimensions like concateting multiple fields as a source and handling the mapping in the conversation file. 

[srshekars]

You are right, That is the reason i posted this seeking help. Is there any way to get 0Amount and 0QTY same time. That is we need all the Accounts with 0Amount and if 0QTY is available it should go to one account. We wanted all QTY in one Account.

[benniejayfguevarra]

Hi,

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

You can use different key figures when using the same MVAL. Just play around with it. 

Thanks,

Bennie