BPC and Data Loads

[Former Member]

Hi all,

I'm sure i've read an article showing me how to automate data loads, (transactional) from the BW into BPC. Does anyone know where i can find the document.

I also would like to know what the function is called. i was sure it was load_infprovider.

[Former Member · Accepted solution]

Here's an article on how to load transactional data from BW to BPC - Once you have the transformation and mapping files ready (as needed), you can then automate this whole process using a PC.

Hope that helps.

Thanks,

[former_member1289965 · Accepted solution]

Hello Nandita, where is the article you are refering to? I have a requirement of moving actual data that is loaded in a BI cube to a BPC one, just looking for some recommendation on that..

Thanks

Sergio

[former_member5075 · Accepted solution]

Hi,

this is the direct link for transactional data upload how to paper: https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0427318-5ffb-2b10-9cac-96ec44c7...

regards,

Sreedhar

[former_member1289965 · Accepted solution]

Thanks Sreedhar, this paper is for exporting data generated in BPC.

I am interested in the other way process, just wanted to import data that is in BI to BPC. The example that is out there is built usiing a very simple cube with only a Key Figure.

What about if I have more that one KF? What is the needed code for converting a KF Model into an Account one??

Thanks

Sergio

[Jeffrey_Holdema · Accepted solution]

In the BPC 7.0 NW release, you have to create a separate transformation file for each key figure you want to load from BI into BPC and run the data load packages separately.

In the next release of BPC 7.5 we plan to address this short-coming and provide a technique to map multiple key figures in a single transformation file.

Best regards,

[Jeffrey Holdeman|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/jeffrey+holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group

[Former Member · Accepted solution]

Hi Jeffrey,

I was wondering, will SAP provide a solution not to work with transformation files anymore to key in the selections of loading. From a functional point of view it makes far more sense to provide input fields (like a normal datapackage for script logic) in which the user kan key in the selection values. By doing so they do not have to create very user-unfriendly transformation files ...

D

[Jeffrey_Holdema]

All of the BPC related How-to Guides are here:

https://wiki.sdn.sap.com/wiki/display/BPX/Enterprise+Performance+Management+%28EPM%29+How-to+Guides

You can read about the standard Data Manager package to [import transaction data from an InfoProvider|http://help.sap.com/saphelp_bpc70sp02/helpdata/en/af/36a94e9af0436c959b16baabb1a248/content.htm] in the SAP help documentation at

http://help.sap.com
SAP Business User > EPM Solutions > Business Planning and Consolidation

.

[Jeffrey Holdeman|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/jeffrey+holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group

[Former Member]

Hi,

there are two HTG available in SDN:

1) Export BPC Transaction Data using Process Chains

2) Automate Master Data load in BPC.pdf

Just search for it in sdn...

Rgds,

Christian