Planning and Consolidation, Version for NetWeaver


How to Load Data from an InfoProvider Using the Data Manager

  • by Pravin Datar, Director, SAP BusinessObjects Planning and Consolidations Solution Management
  • September 23, 2011
Learn the pros and cons behind various alternatives, including useful features that you can use while creating transformation and conversion files.
Key Concept
When it comes to loading data from a SAP NetWeaver BW InfoProvider to SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver, the best way is to make use of the standard Data Manager package. You can use various features available in the package’s transformation and conversion files to configure dimensions, multiple key figures, and data selection.

SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver uses the SAP NetWeaver infrastructure, which means you can use data stored in InfoCubes in the enterprise data warehouse. The planning and consolidation application also uses Data Manager packages to move data into SAP BusinessObjects Planning and Consolidation, as well as copy and move data within and across applications.

You can configure and execute these Data Manager packages from within Microsoft Excel’s interface. The Data Manager also allows you to schedule these packages to run at a given time. The packages use SAP NetWeaver BW process chains extensively. You can automate execution of Data Manager packages by creating custom process chains.

Note
SAP BusinessObjects Planning and Consolidation is available in two versions: Microsoft version and SAP NetWeaver version. This article discusses the NetWeaver version only.

Loading Data from an InfoProvider 

Let’s discuss how to load data from any InfoProvider to an application in SAP BusinessObjects Planning and Consolidation starting with an evaluation of all the options to perform such data loads. Many options are available to users to get transactional data from an SAP NetWeaver BW cube to an application in SAP BusinessObjects Planning and Consolidation. including the following three:

Pravin Datar

Pravin Datar works as director in the Enterprise Performance Management (EPM) Solution Management team at the SAP BusinessObjects Division. He has more than 20 years of business experience that includes management consultancy, ERP project management, and SAP SEM, BPC RIG, and EPM solution management. He holds a master’s degree in industrial engineering and an MBA from University of California.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.