skip columns in transformationfile

[Former Member]

Hi

We are running BPC NW 7.0

From SAP we get a flat file withthe following layout:

dimension;dimension;dimension;dimension;dimension;dimension;jan;feb;marts;april;may;june;july;august;september;okt;nov;dec;

The file has header.

We now have a need only to load fx figures for april.

I want to fix that in the transformation/ and - or conversionfile.

Anyone who knows a solution?

I want to avoid a reprogramming of the extract from SAP. And we are running this by FTP so I will not interphere in the process and do something in Excel with my file. I have this way to load app 80 files every night.

Kind regards

[Former Member]

Hi

We found the solution ourselves, thanks to some blogs on google.

It was just a fancy combination of transformationfile and conversionfile

[Former Member]

Hi

I am aware of that mval statement and this is in place. When we load figures for all month it works smoothly.

I have tried to change the mval statement only to point at one period, but that gives me a syntax error message.

So somehow I need to tell that I only want to import one of my time columns.

Our normal time statement says

TIME = *MVAL(7:18)

I tried to change it to

TIME = *MVAL(12:12)

but then I got the syntax error when I loaded.

I am missing a statement where I can tell the system to skip some columns.

changing the file from the keyfigure model to an account model does not work either, as I cant set up the statement to skip all the other lines for the months I dont want to load

Kind regards

[Former Member]

Hi,

Your flat file has the key figure model. However, BPC is an account based model. This means that the flat file needs to be converted to the account based model.

You need to use the *MVAL statement in the transformation file. Please take a look at the MVAL statement in the mapping section of the below link from help.sap:

http://help.sap.com/saphelp_bpc70sp02/helpdata/en/5d/9a3fba600e4de29e2d165644d67bd1/content.htm

Hope this helps.