SAP Communit Network Blogs
Log In Register About Us How to Contribute Languages Store
Home Fo m Wiki Blogs
A icle eLea ning
Business Anal tics
Ca ee Cen e
E en InnoCen i e Idea Place SAP Help Po al
Code E change
MEMBER LOGIN Log in Fo go o pa o d?
No a membe ? Ho o Blog
Loading transactionaldata from an infocube to BPC Application in BPC7NW
Pravin Datar Business Card Compan : SAP Business Objects Posted on Apr. 16, 2009 06:54 PM in Enterprise Data Warehousing/Business Warehouse, Enterprise Performance Management
Blog b Da e Blog b Ca ego Top Blog Po Ac i e Blogge Podca C ea e/Upda e A ho Page Blogge Home E pe Blogge Home Con ib o Co ne
Business Planning and Simulation version forNetweaver successfully leverages the Netweaver infrastructure and we can use the data store infocubes in the Enterprise Data Warehouse in BPC7NW. In this blog we will discuss what tools and techniques we can use to get the transa stored in any infocube in BW into BPC Application using Data Manager in BPC7NW. Options available for cube to cube data load:
CONTRIBUTORS CORNER Contribute on SCN Ho oCon ib e Recogni ion P og am O e ie Recogni ion P og am FAQ Quick Links Li of Con ib o Find he E pe Con ib ing Companie SAP Men o RUN BETTER WITH SCN Lea n ho C ome and Pa ne RUN BETTER Con a Inc., CTO e SCN Wal Di ne Compan e SCN Ha le -Da id on e SCN Bo e e SCN Blog on SAP C ome Panel a SAPTechEd
There are many options available to the users of BPC7NW to get transactional data from a BW cube toBPC Application. Here are some of th 1. We can export the transactional data from any infocube in the form of flat file and then use Data Manager in BPC7NW to load that file to BPC Application. The advantage of this option is that it is relatively very simple to administer and very flexible to adapt since dealing with a flat file when it comes to importing data into BPC Application. Thelimitation of this option is that here we are really no the BW platform. If we have to load data from any other non-BW source, we can use exactly the same approach - export data fro external data source to a flat file and then import that flat file into BPC. So in essence, in this option we are treating BW infocube a external data source. There is another ostensible limitation that this option may portray- that this process can not be automated. I get a flat file export from an infocube and then import that flat file into BPC, then it may appear that there has to be a handoff from export to the import of flat file. However we can overcome this limitation, if we want to, by creating a custom process chain that in executes the process chain to import the flat file data into BPC Application. You canread more about that at https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/12929 2. We can leverage BW Extraction, Transformation and Loading (ETL) tools to transfer transactional data from any infocube to the inf by BPC Application. BPC Application in BPC7NW generates its own infocube in its namespace. We can use standard BW ETL techniq transform and load the data to the cube used by the BPCApplication. (You can read more about BPC namespace at https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11279). This option also is valid one and it indeed leverages the BW platf this can very well be automated if we desire to do so. Further this option can handle deltas very efficiently since we can use the de mechanisms in BW. Lastly, using the ETL toolset is a proven, scalable and veryrobust technique to handle data within BW. Howeve also beset with several limitations. Firstly, infocube for the BPC Application will need to be switched to loading mode while loading it then switch it back to planning mode after loading is complete. This means that during that time, it will not be available for planning front end. So the ETL load has to coordinated with the BPC users to avoid any...