Migrate Your SAP BW 3.x Data Flow to Upgrade to SAP NetWeaver BI 7.0’s New Features and Functionalities

  • by Kedar Patil, Senior Consultant, Infosys Technologies Limited
  • Umesh Manoor, Senior SAP BI Consultant, Fujitsu Consulting
  • December 15, 2009
When you upgrade from SAP BW 3.x to SAP NetWeaver BI 7.0, the data flow doesn’t automatically migrate with the system. Find out how to migrate your DataSources, transformations, and Web templates to the new format.
Key Concept

A transformation is a new SAP NetWeaver BI 7.0 structure or vehicle that moves data from the Persistent Staging Area (PSA) to its target, such as a DataStore Object (DSO) or an InfoCube. The transformation maps the source fields and objects to the target. In fact, any data flow beyond the PSA is in the form of a transformation. It replaces the update rules and transfer rules of SAP BW 3.x. Transformations can also handle any additional logic, cleansing, or simple field-passing that update rules can.

As SAP decreases its support for older versions of its business intelligence and reporting software, the demand to upgrade from SAP Business Information Warehouse (SAP BW) 3.x to SAP NetWeaver Business Intelligence (SAP NetWeaver BI) 7.0 has significantly increased. As a result, businesses are looking for simple, efficient ways of successfully migrating the data, data models, and user interfaces (UIs) that they built in SAP BW 3.x.

This article follows the flow of data from DataSources through transformations, Data Transfer Processes (DTPs), and InfoProviders to the data mart or down-line system, as shown in Figure 1. It discusses the two options you have for migrating your DataSources: Emulate before you migrate, and migrate immediately. Then, the article explains how to migrate your transformations (which replace the update rules and transfer rules from SAP BW 3.x) to SAP NetWeaver BI 7.0. Next, the discussion moves to DTPs and Web templates. A Web template is a browser- based template (containing header, footer, logos, navigation blocks, etc.) to which you can publish reports and display them on the Web. You can publish multiple reports to the same template. Along the way, there are tips for consolidating some of these processes. For SAP NetWeaver BI consultants or team members, this article provides a good way of managing the data in your upgraded system landscape.

Kedar Patil

Kedar Patil has been working in the SAP field for nearly eight years. He has spent more than five years in the SAP BW/BI space working on design, architecture, and development. He has also been involved with BW upgrade projects and assessments. Kedar has rich experience leading and managing global implementations and support assignments for various international clients. He started his career as an ABAP programmer and then moved into the SAP BW space. His hobbies include adventure sports, playing cricket, and reading.

See more by this author

Umesh Manoor

Umesh Manoor is a senior SAP NetWeaver BI consultant working at Fujitsu Consulting. He has more than five years of extensive experience on project scoping, analysis, design, development, and reporting. Umesh has also been involved in SAP BW/BI upgrade/migration projects with multiple customers. He has worked with large international clients in Europe and North America across various techno-unctional areas, handling complex BI solutions. He started his career as a fabric design engineer and then moved into the SAP BI area.

See more by this author


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.