Transfer Data from Standard BI Cube to BPC cube ?

[Former Member]

Dear All,

I am trying to load data from Standard BI cube to BPC cube. Here I need to map key-figure model to account model, could you please tell me the ways to achieve this.

Regards

Rupa

[Former Member · Accepted solution]

Hi Rupa,

For example: BI cube has 3 characteristics material, region, customer and 3 Key Figures Revenue, cost & Overhead

M1 R1 C1 50 20 10

M2 R2 C2 100 30 30

M3 R3 C3 70 30 20

BPC Cube will have 4 dimensions i.e. Material, Region, Customer, Account and one key figure SignedData.

Where in Account will have members as Revenue, Cost & Overhead.

BPC Cube data will look like this

material Region Customer Account Amount

M1 R1 C1 Revenue 50

M1 R1 C1 Cost 20

M1 R1 C1 Overhead 10

M2 R2 C2 Revenue 100 ....... and so on.

When you upload data from BI cube to BPC cube

You should use transformations which will update 3 records into BPC cube for every one record in BI Cube.

Using condition on the key figure you should assign Account with Revenue, Cost or Overhead.

Note: BPC cube has one KF (Signed Data) which will be update with 3 Key Figures data but in separate records.

Hope you are good now to upload BI cube data to BPC cube!

Regards,

Rajesh Muppala.

[Former Member · Accepted solution]

Hi Rajesh,

Thanks for the reply. Could you please tell me more about writing transformations for loading BI to BPC cube.

Example code would be appreciated.

Thanks

Rupa

[Former Member · Accepted solution]

Hi Rupa,

Are you able to build the transformation file for your requirement. If so , Then can you please share it or give me some idea about it.

Thanks

Sanjay

[Former Member · Accepted solution]

Hi all,

To create a transformation file, you need to be connected to BPC for excel interface and you go to the menu eData => New tranformation file. If you are not able to see this task, check your security task profile.

I advise you to create 1 transformation file by ratio:

1 transformation file to import Revenue from BI to BPC: you will have in the mapping section

*MAPPING

ACCOUNT = *NEWCOL(REVENUE)

AMOUNT = K_REVENUE

Where Amount is the BPC key figure and K_REVENUE is you BI key figure

1 transformation file to import Cost from BI to BPC: you will have in the mapping section

*MAPPING

ACCOUNT = *NEWCOL(COST)

AMOUNT = K_COST

Where Amount is the BPC key figure and K_COST is you BI key figure

1 transformation file to import Cost from BI to BPC: you will have in the mapping section

*MAPPING

ACCOUNT = *NEWCOL(OVERHEAD)

AMOUNT = K_OVERHEAD

Where Amount is the BPC key figure and K_OVERHEAD is you BI key figure

I hope this help

Regards

Virginie

[Jeffrey_Holdema · Accepted solution]

Indeed in BPC 7.0 NW, 3 transformation files and Data Manager package loads would be required to import three source BW key figures into BPC.

The good news in BPC 7.5 NW, the *MVAL keyword which prviously was used to transform fiiles with multiple time dimensions (think 12 columns of monthly signdata) has been repurposed and now also supports multiple key figures. For example, in one transformation file, you can grab both 0BALANCE and 0QUANTITY key figures and map them to account dimension members as such:

ZACCOUNT=MVAL(0BALANCE|NEWCOL(0000800000)||0QUANTITY|*NEWCOL(ZQUANTITY))

BPC 7.5 NW is currently restricted to ramp-up customers. Ramp-up is expected to run from Dec-2009 to 2Q-2010.

Thanks and best regards,

[Jeffrey Holdeman|http://wiki.sdn.sap.com/wiki/display/profile/Jeffrey+Holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group

[Former Member · Accepted solution]

Jeffrey,

why doesn't SAP provide the possibility to key in your selections in the data package itself, instead of doing this in an transfomation file. This cannot be that hard from a technical point of view ... I'm dissapointed this is not provided iin 7.5 version ...

[Jeffrey_Holdema · Accepted solution]

I don't know the history of the design storing selections in transformation files vis-a-vie the packages, since it dates back to the Osoft days. But to give my opinion, I would say to do so would conflict with the reusability of the packages across different selections. While putting them in the transformation files provides a convenient container to save files for repeat usage.

If you can come back with a good use case and example where your idea makes more sense, I'd be glad to pass it along to Solution Management.

Thanks and best regards,

[Jeffrey Holdeman|http://wiki.sdn.sap.com/wiki/display/profile/Jeffrey+Holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group

[Former Member]

The repurposing of MVAL to support multiple key figures will be extremely helpful for some our transformations. Is this limited only to the NW version, or does it also apply to 7.5 MS?