An Overview of Simplified Modeling with SAP BW on SAP HANA (Part 1)

  • by Ned Falk, Senior Education Consultant, SAP
  • April 26, 2016
Learn how the move to SAP BW running on SAP HANA makes SAP BW both faster to use and simpler to deploy.
Learning Objectives

Reading this article, you will learn:

  • About the newest SAP BW InfoProviders and which older InfoProviders they are designed to replace
  • Why the old objects were used and why these new ones are better, simpler, or both
Key Concept
InfoProviders are the objects against which BEx Queries are written. BEx Queries, in turn, feed data to reporting tools. In the beginning, InfoCubes were the lone InfoProviders, but over time, more types of InfoProviders were created. Now, going full circle with SAP BW running on SAP HANA, the technology has been simplified, leaving a very short list of InfoProviders and thereby reducing the complexity of BW implementations.

Although most companies currently run SAP Business Warehouse (SAP BW) on traditional disk-based databases, many companies that I deal with are in the process of migrating or greenfielding (i.e., starting a project from scratch) their SAP BW systems to run on the in-memory computing power of SAP HANA. By adopting SAP HANA as the underlying database for SAP BW, companies realize immediate performance gains. SAP BW running on SAP HANA leverages the power of the database to create new InfoProviders that simplify the SAP BW modeling process. These new InfoProviders are designed to replace older ones. This transition should occur as soon as possible after a migration to the SAP HANA database to gain the most performance benefits, as well as for simplification.

Figure 1 shows the newest list of InfoProviders for companies running SAP BW on SAP HANA. It also shows the old InfoProviders used by BW when not running on the SAP HANA database.

Figure 1
The older InfoProviders and the new ones that replace them in SAP BW on SAP HANA

Figure 1 is a bit confusing in the area of CompositeProviders. Although the name is the same, the newer CompositeProvider is a different underlying object that offers more features.

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


Please log in to post a comment.

To learn more about subscription access to premium content, click here.