Open Hub Transformation Meets Complex Business Requirements

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • October 1, 2006
You can use open hub transformation any time you need to alter extracted data. This method offers a great deal of flexibility and customization because it relies on ABAP code to transform data.
Key Concept

Open hub allows BW to act as a source to distribute data to systems outside of BW. It extracts data from BW’s InfoCubes, DataStore objects (formerly operational data store [ODS] objects), and master data. It then sends that data to external destinations as either a relational database table or a flat file. Transforming data in open hub requires ABAP coding in the form of a custom Business Add-In (BAdI).

The nature of many IT organizations dictates that information needs to flow not only into the BW system, but also out of BW into other systems. For example, your sales team needs BW data to feed a third-party transactional system. This system tracks and maintains shipping orders on a monthly basis. The third-party package has specific data storage requirements. To get the data out of BW into this third-party shipping system, you can use open hub. However, open hub extracts data in its current form. You often need to translate the data to comply with the third-party system’s data requirements, such as a five-digit material number or a leading zero at the beginning of each field. To satisfy these requirements, use custom ABAP code in the open hub transformation Business Add-In (BAdI).

In my example, SAP has a four-character alphanumeric plant field 0PLANT, but the third- party system requires a five-character numeric field for plant. During extraction, you must convert the plant field. Open hub transformation can perform the translation in just three steps: Set up the InfoSpoke, configure open hub transformation, and write custom ABAP code.

Gary Nolan

Gary Nolan is an SAP NetWeaver BW-certified consultant and author of Efficient SAP NetWeaver BW Implementation and Upgrade Guide and Efficient SAP NetWeaver BI Implementation and Project Management. Gary specializes in gathering and evaluating requirements, configuring SAP NetWeaver BW, and providing project management, performance management, and data architecture and data modeling expertise. A former platinum consultant with SAP America, Inc., Gary has more than 20 years of SAP experience, working with SAP NetWeaver BW since version 1.2B.

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.