BPC NW Account based model data load using flat file

[Former Member]

Hi,

Model - Account based

I have a file with multiple key figures spread across columns. I have tried to use MVAL function to map the key figures to respective Account dim members. However mapping validation fails in Transformation file. ACCOUNT=*MVAL(*COL(75)|*NEWCOL(TONSOLD)||*COL((84)|*NEWCOL(TOTNTSALE)) Is this a valid syntax for csv files?

Regards

[former_member186338 · Accepted solution]

First of all - incorrect primary tag! Please change it to: SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

Second: I can comment on the syntax only if you show the line of the data file! Please read about syntax here:

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/5d/9a3fba600e4de29e2d165644d67bd1/content.htm?frame...

[former_member186338 · Accepted solution]

P.S. Do you have header line in the data file? Please show it!

[Former Member · Accepted solution]

Yes, i do.

Plant || Customer || Material || Time || Qty Sold || Total sales

I am mapping last two key figures to Account dimension. The equivalent dimension members of Qty Sold and Total sales in my Account dimensions is QTYSOLD and TOTSALES

I can write to two transformation files one each for Qty Sold and Total sales, however I am looking to accommodate all in one file

Regards

[former_member186338 · Accepted solution]

Sorry, but what do you mean by *COL(75) I don't see 75 columns, only 6 🙂

What is the delimiter?

[Former Member · Accepted solution]

🙂 I have listed only required fields, i have close to 100 columns in the file

delimiter is , (comma)

[former_member186338 · Accepted solution]

Instead of col(75) you can use a column name from the header line. Your syntax is slightly incorrect - "(" has to be removed near col(84)

[Former Member · Accepted solution]

Yep it works!

I have replaced the col number with the column name.

One learning is column name should not contain spaces

column name e.g.

Qty sold - will not work

Qtysold - will work

Final syntax -

ACCOUNT=*MVAL(TonsSold|*NEWCOL(TONSOLD)||TotalNetSales|*NEWCOL(TOTNTSALE))

Thanks for the inputs Vadim

Regards