The Easy Way to Get Data from Planning and Consolidation to SAP NetWeaver BW

  • by Ashish Narway, Senior Consultant, Planning and Consolidation and Business Intelligence
  • March 9, 2012
Through written instruction and a collection of video demos, learn how to extract data from SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver and store it in SAP NetWeaver BW without writing complex ABAP code or logging on to the SAP NetWeaver back end to start the extraction.
Key Concept
Data Manager is an SAP BusinessObjects Planning and Consolidation module that helps you move data into the planning and consolidation system, copy and move data within and across applications, and export data from an application by means of packages. Data Manager packages are based on process chains, which are sequences of processes that are scheduled to wait in the background for an event. Some of these processes trigger a separate event that can, in turn, start other processes.

When SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver was released, a promising feature was the ability to consume the data in planning and consolidation applications and use it for comparative analysis in SAP NetWeaver BW. This data must remain consistent between the two applications.

For example, business users often want to report actual revenue or volume against planned revenue or volume. Users can also plan targets and budgets in SAP BusinessObjects Planning and Consolidation and compare the targets against actual revenue.

Since SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver runs on top of SAP NetWeaver BW, this data extraction should have been fairly straightforward. However, SAP BusinessObjects Planning and Consolidation 7.0 and 7.5, versions for SAP NetWeaver do not provide such built-in functionality. There are options available, but each has its own limitation:

  • Retraction Business Add-In (BAdI): SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver allows you to use a retraction BAdI for the extraction, but doing so requires ABAP OO coding and makes it less flexible when changes are requested by business.
  • Open hub: Via SAP NetWeaver BW functionality, this step lets you use the InfoCube created by the planning and consolidation application to extract data to either a flat file or table. The drawback is that the user needs access to the back-end SAP NetWeaver BW system and requires knowledge to modify SAP NetWeaver when changes are requested.
  • Data transfer process (DTP): You can create a DTP on the InfoCube generated by the planning and consolidation application to extract data to other InfoProviders. However, the creation of a DTP on the InfoCube leads to issues during transports from development to production and application copy in SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver.

I propose a custom solution that enables the extraction of data within the SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver Data Manager package, while providing selection criteria and the ability to add business logic.

Ashish Narway

Ashish Narway is an SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver architect, certified SAP NetWeaver BW Solution consultant, SAP financial and controlling solution consultant, and Project Management Professional (PMP) with more than 13 years of experience. In his tenure with Tata Consultancy Services, Limited, he has successfully led planning and consolidation and SAP NetWeaver BW implementations, as well as upgrade and support projects for large, multinational companies in the high tech, industrial machinery, construction, telecommunications, and manufacturing Industry industries.

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.