Skip to Content
0

BPC NW Account based model data load using flat file

Oct 31, 2016 at 06:48 PM

54

avatar image

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

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
0

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?frameset=/en/e9/23ece2cfd7489f8aa457d78d306a38/frameset.htm¤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!

0

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

0

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

What is the delimiter?

0

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

delimiter is , (comma)

0

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)

1

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

0