An Overview of Simplified Modeling with SAP BW on SAP HANA (Part 2): Using Advanced DataStore Objects

  • by Ned Falk, Senior Education Consultant, SAP
  • July 15, 2016
Learn the basics about the new SAP BW on SAP HANA advanced Data Store object (DSO) and how it compares to InfoCubes and the older DSOs for SAP BW not running on SAP HANA.
Learning Objectives

Reading this article, you will learn how to:

  • Describe the new SAP BW advanced Data Store object (DSO)
  • Understand where (in which user interface) the new advanced DSO can be built
  • Compare this new advanced DSO with the older InfoPoviders it replaces
  • Understand the performance improvements of the advanced DSO for SAP BW on SAP HANA versus standard DSOs for SAP BW on non-SAP HANA databases
  • Understand the new features offered by the advanced DSO
Key Concept

The new advanced Data Store object for companies running SAP BW on SAP HANA is a flexible, high-performing InfoProvider. It leverages the SAP HANA database to improve the processing of data, while at the same time allows for multiple deployment options that change how it can be used in an SAP BW data warehouse.

In this follow-up to my other BI Expert article, “An Overview of Simplified Modeling with SAP BW on SAP HANA (Part 1),” I focus on the details of the advanced Data Store object (DSO) and how to use it. As the name suggests, the advanced DSO has a lot in common with the original DSOs from SAP BWs not running on SAP HANA. However, it is a much more flexible object. This flexibility is an improvement over the prior DSOs, and includes the ability to selectively control how, or even if, all of the three tables (which are the technical underpinnings of the advanced DSO) are used. This flexibility, combined with additional features such as support for planning applications, means that this one object can simplify your SAP BW architecture by replacing all your existing DSOs, InfoCubes, and even persistent staging areas (PSAs).

Positioning and Architecture of the Advanced DSO

Figure 1 shows the older SAP BW InfoProviders and the newer ones that can replace them, but only when for companies running SAP BW on SAP HANA, The advanced DSO, the subject of this article, is a replacement for all objects in SAP BW that have persistent storage. This includes all the previous types of DSOs, as well as PSAs.

Figure 1
A comparison of the new simplified InfoProviders with the earlier objects

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


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.