BPC Data Transformation

[Taketa]

Hello BPC Experts,

I'm creating a BPC MS version demo environment for our prospect customer.

To import the data from the external system, I got the excel data file from them.

In the excel file, there're more than one Account's value in one line;

(Customer's Excel File)

ENTITY RowMaterialCost ProductCost SubcontractingCost ConstructionCost

A01 1000000 2000000 3000000 4000000

B01 5000000 6000000 7000000 8000000

C01 9000000 1000000 2000000 3000000

To import these 4 data via Data Manager, should I split one row into 4 per ENTITY

like below or is there any tool or transformation method so that

I don't have to convert the original file?

ENTITY,TIME,CATEGORY,ACCOUNT,AMOUNT

A01,2010.JUN,ACTUAL,ROWMATCOST,1000000

A01,2010.JUN,ACTUAL,PRODUCTCOST,2000000

A01,2010.JUN,ACTUAL,SUBCONCOST,3000000

A01,2010.JUN,ACTUAL,CONSTCOST,4000000

For the other required dimensions such as ENTITY/TIME etc

which are not shown in the customer's excel file,

I created a transformation file with the following syntax;

ENTITY=*NEWCOL(A01)

I've just started to learn BPC since May, so any advice would be really appreciated.

Thanks in advance,

Fumi Takeuchi

[Taketa]

Hi Nilanjan,Wandi,

Sorry for my late reply...and many thanks for your helpful information.

Nilanjan,

I seems that MVAL statement can be used for TIME dimension.

(When I try to use MVAL for ACCOUNT dimension, I got an error such as

"Required dimension:TIME=*MVAL(2:5)]")

So next, I want to try MKEY statement described in your link, but I assume that this can be used from BPC 7.0 or 7.5 version.

Example:

Account=MKEY(LC|NEWCOL(Cash_lc)||GC|COL(1)+STR(gc)||TC|*NEWCOL(Cash_tc))

Since my BPC is still 5.1 and we're planning to install the latest version this month, I'll try to use MKEY and investigate a little more as soon as BPC 7.5 is installed.

I'll update the status in this forum then.

Thanks,

Fumi

[Former Member]

Hi Fumi!

Just to ask something about this, I'm having the same problem, If you use MKEY, does it work?

regards

[Taketa]

Hi Miguel,

Unfortunatelly, our system is still 5.1 version and this version doesn't seem to support "MKEY" statement.

(The system can't recognize "MKEY" with error when checking and saving the transformation file)

So, I'm waiting for a new version 7.5 installed in our environment.

Sorry for not being able to give you any useful information.

Warmest regards,

Fumi

[former_member599120]

Dear Fumi Takeuchi,

The first step you should to configure the transformation file, its file contains columns map base on your dimensions. For more information about transformation you could open BPC Excel help. After that, you dump your client's data into text file (.txt) or CSV file format. The order of data inyour text file or CSV file must same with your transformation file.

Maybe you can read transformation file configuration in above link.

For your case, Yap you're right.

Kind Regards,

Wandi Sutandi

[Former Member]

Hi,

You should try using the MVAL statement. Please refer to the MVAL statement in the mapping section in the below link for further information.

http://help.sap.com/saphelp_bpc75/helpdata/en/a2/e722bc58404335ada8592cdc8feaca/content.htm

Hope this helps.