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.
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
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.
A comparison of the new simplified InfoProviders with the earlier objects
Would you like to see this full item?