Skip to Content

BPC Data Transformation

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2010 at 03:33 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 15, 2010 at 12:57 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2010 at 01:07 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.