Skip to Content

BPC NW Account based model data load using flat file

Oct 31, 2016 at 06:48 PM


avatar image


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?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Oct 31, 2016 at 07:08 PM

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:¤t_toc=/en/66/348113c47b4ae7b2f068b88047d02b/plain.htm&node_id=142&show_children=false

Show 6 Share
10 |10000 characters needed characters left characters exceeded

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


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



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

What is the delimiter?


:-) I have listed only required fields, i have close to 100 columns in the file

delimiter is , (comma)


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)


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 -


Thanks for the inputs Vadim