Quick Tip: Quickly Create BW Data Flow Objects in SAP BW 7.4

  • by Ned Falk, Senior Education Consultant, SAP
  • April 20, 2015
Learn about the new SAP BW 7.4 feature that allows users to instantly make data flow objects from the pre-SAP BW 7.3 ETL components that were previously created via the older context-menu—right-click—method.

An SAP BW data flow object is an editable tool to graphically build the extraction, transformation, and loading (ETL) process (sometimes called a data flow) to move data from a source system to a BW object. As of SAP BW 7.3 there are two ways to create this data flow.

With the introduction of data flow objects, new as of the SAP BW 7.3 release, there was a tool that allowed SAP BW users to easily construct an extract, transform, and load (ETL) process as well as build targets and sources, all graphically. Most users, especially BW beginners, like to see a graphical picture using the new method. With the release of SAP BW 7.4, there is new feature that allows the instant creation of a data flow object if the ETL process was already built using the prior technique. To easily switch over to this newer modeling feature from the older context-menu-based (right-click) method, you need to create these new objects based on your existing ETL models.

I show how you can easily do this by using two different techniques.

An Overview of SAP BW ETL-Related Terms and Objects

As experienced BW people would know, in older versions of SAP BW (before SAP BW 7.3), InfoProviders and data sources were nearly all created via the context menu in the appropriate modeling area of the Data Warehousing Work Bench. For example, under Modeling in transaction code RSA1, users select the InfoProviders area, right-click an InfoArea, and then choose either Create InfoCube or Create Data Store Object. Similarly, to create the transformations and the data transfer processes, you again need to right-click the appropriate object and choose, for example, Create Transformation.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

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.