Tips and Tricks for Data Conversion in SAP NetWeaver BW and SAP BusinessObjects Planning and Consolidation

  • by Jens Koerner, Product Manager, Mobile Platform, SAP Labs
  • Patricia Pohl, Senior Consultant, Business & Decision
  • April 5, 2010
Automating data loads from SAP ERP and SAP NetWeaver BW into SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform is not a trivial task. Creating new SAP BusinessObjects Planning and Consolidation InfoObjects in SAP NetWeaver BW while keeping the original standard objects allows you to create an audit trail of all the transformations you performed and to facilitate data reconciliation. Using reports in SAP NetWeaver BW and SAP BusinessObjects Planning and Consolidation, you can match up the data after loading.
Key Concept
Companies running SAP BusinessObjects Planning and Consolidation often wish to use their existing SAP ERP and SAP NetWeaver BW data for planning and consolidation in SAP BusinessObjects Planning and Consolidation. However, you may encounter common data transformation challenges such as matching SAP NetWeaver BW multiple key figure models to the generic one key figure model in SAP BusinessObjects Planning and Consolidation. In addition, you could face data format challenges such as data signage.

Integrating data from SAP ERP into SAP BusinessObjects Planning and Consolidation may be likened to using a European hair dryer in the US. First of all, the European plug does not fit into the US outlet, so you need a converter. Once connected the European dryer underperforms as it needs 240 volts while the US runs on 110 volts — thus you need to transform the 110 volts into 240 volts to achieve full performance.

You can plug SAP NetWeaver BW and SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform together using the open hub service and Microsoft SQL Server Integration Services (SSIS). SAP NetWeaver BW and SAP BusinessObjects Planning and Consolidation Data Manager can take over the role of the transformer to ensure that the SAP data loaded into SAP BusinessObjects Planning and Consolidation is correct and reflective of what the user expects.

You have two challenges to overcome to load SAP data into SAP BusinessObjects Planning and Consolidation:

  • Connect SAP ERP and SAP BusinessObjects Planning and Consolidation
  • Transform the data to load it into SAP BusinessObjects Planning and Consolidation

We describe techniques to load data from SAP NetWeaver BW into SAP BusinessObjects Planning and Consolidation. Although we focus on SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform, most of the conversion tricks equally apply to the version for SAP NetWeaver. The information in this article applies to SAP BusinessObjects Planning and Consolidation 5.x and 7.0.

Jens Koerner

Jens Koerner is product manager, Mobile Platform, at SAP Labs. Previously, he was senior director, leading the SAP Enterprise Performance Management (EPM) and Business Intelligence (BI) Customer Solution Adoption team. He also was a senior director-level SAP enterprise architect and project manager focused on the development of SAP solutions such as SAP Business Warehouse (SAP BW) or SAP Business Planning and Consolidation (SAP BPC). He has led global implementations with various customers in the US, the UK, and Germany and was a member of the Inforte BI leadership team.

See more by this author

Patricia Pohl

Patricia Pohl is a senior consultant at Business & Decision. She has worked on various SAP NetWeaver BW and SAP BusinessObjects Planning and Consolidation projects in the US, Canada, and Germany.

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.