Introduction

This blog serves the purpose to help new customers to successfully onboard to SAP Datasphere. It should especially be addressed to customers who are used to the SAP Business Warehouse (SAP BW) environment and are now starting to work in SAP Datasphere. E.g. as a BW developer, I know how to create an InfoObject and select the respective settings for hierarchies, texts, language-dependency etc. How would I do that natively in SAP Datasphere? This video series will answer these questions and covers the native implementation in SAP Datasphere.

Demo Series Overview

InfoObjects

Hierarchy with Directory

There are some cases where you have to manually create a hierarchy in SAP BW. Therefore, in this video, I will show you an end-to-end process on how you can leverage hierarchies in SAP Datasphere, specifically hierarchies with directory. A hierarchy directory would list all hierarchies in a given context. For more information, please refer to SAP Help | Create a Hierarchy with Directory. Please note that you can also create a hierarchy without directory (see SAP Help | Add a Hierarchy to a Dimension).

Advanced DataStore Objects

Transformation Flow & Local Tables

Advanced DataStore objects (aDSO) are common in SAP BW/4HANA to store and consolidate data. In this video, I will show you the equivalent use case when loading data with a transformation into a Standard aDSO with Change Log. For that, we will leverage a delta-enabled local table (e.g. as a target entity in a Replication Flow) in a Transformation Flow for data transformation, and write the result into a different delta-enabled target table. For more information, please see SAP Help | Capturing Delta Changes in Your Local Table and SAP Help | Creating a Transformation Flow.

Queries

Analytic Model – Key Figures

In SAP BW, you can define a variety of different key figures in a BW query such as calculated or restricted key figures. In SAP Datasphere you have the same capabilities within the Analytic Model. In this video, I will showcase the creation of calculated measures with and without an exception aggregation, and restricted measures. For more information, please see SAP Help | Create a Calculated Measure and SAP Help | Create a Restricted Measure. Please note that you can also create a count distinct measure which is not covered in this video (see SAP Help | Create a Count Distinct Measure).

Analytic Model – Variables & Derivations

BW developers are heavily implementing exit variables in BW queries to provide e.g. dynamic filtering options for data analysis. In SAP Datasphere, we can leverage derivations in the Analytic Model to achieve an equivalent solution. Hence, in this video, I will show you how to implement variables with derived values. the For more information, please refer to SAP Help | Create a Standard Variable, SAP Help | Derived Variables and SAP Help | Create an Input Parameter).

Conclusion

In this blog, we started with SAP BW objects and showed an equivalent solution in SAP Datasphere in accordance to the SAP BW functionality. Apart from the capabilities shown, SAP Datasphere offers even more features such as the Data Marketplace, Catalog and data integration of SAP and non-SAP solutions to enable the Business Data Fabric.

Please note that the detailed outlining of the respective capabilities in SAP Datasphere can also be automatically imported via the Import Entities option if you have an SAP BW/4HANA or BW Bridge in place (please see SAP Help | Importing Data Models from SAP BW).

This is the second part of the BW series. The first part, covering text and language dependency, navigation and transitive attributes, time-dependency, currency conversion and hierarchy with Business Content, can be accessed here: SAP Blogs | SAP Datasphere: BW Series – Getting Started (Part 1). Introduction This blog serves the purpose to help new customers to successfully onboard to SAP Datasphere. It should especially be addressed to customers who are used to the SAP Business Warehouse (SAP BW) environment and are now starting to work in SAP Datasphere. E.g. as a BW developer, I know how to create an InfoObject and select the respective settings for hierarchies, texts, language-dependency etc. How would I do that natively in SAP Datasphere? This video series will answer these questions and covers the native implementation in SAP Datasphere. Demo Series OverviewInfoObjectsHierarchy with DirectoryThere are some cases where you have to manually create a hierarchy in SAP BW. Therefore, in this video, I will show you an end-to-end process on how you can leverage hierarchies in SAP Datasphere, specifically hierarchies with directory. A hierarchy directory would list all hierarchies in a given context. For more information, please refer to SAP Help | Create a Hierarchy with Directory. Please note that you can also create a hierarchy without directory (see SAP Help | Add a Hierarchy to a Dimension). Advanced DataStore ObjectsTransformation Flow & Local TablesAdvanced DataStore objects (aDSO) are common in SAP BW/4HANA to store and consolidate data. In this video, I will show you the equivalent use case when loading data with a transformation into a Standard aDSO with Change Log. For that, we will leverage a delta-enabled local table (e.g. as a target entity in a Replication Flow) in a Transformation Flow for data transformation, and write the result into a different delta-enabled target table. For more information, please see SAP Help | Capturing Delta Changes in Your Local Table and SAP Help | Creating a Transformation Flow. QueriesAnalytic Model – Key FiguresIn SAP BW, you can define a variety of different key figures in a BW query such as calculated or restricted key figures. In SAP Datasphere you have the same capabilities within the Analytic Model. In this video, I will showcase the creation of calculated measures with and without an exception aggregation, and restricted measures. For more information, please see SAP Help | Create a Calculated Measure and SAP Help | Create a Restricted Measure. Please note that you can also create a count distinct measure which is not covered in this video (see SAP Help | Create a Count Distinct Measure).Analytic Model – Variables & DerivationsBW developers are heavily implementing exit variables in BW queries to provide e.g. dynamic filtering options for data analysis. In SAP Datasphere, we can leverage derivations in the Analytic Model to achieve an equivalent solution. Hence, in this video, I will show you how to implement variables with derived values. the For more information, please refer to SAP Help | Create a Standard Variable, SAP Help | Derived Variables and SAP Help | Create an Input Parameter). ConclusionIn this blog, we started with SAP BW objects and showed an equivalent solution in SAP Datasphere in accordance to the SAP BW functionality. Apart from the capabilities shown, SAP Datasphere offers even more features such as the Data Marketplace, Catalog and data integration of SAP and non-SAP solutions to enable the Business Data Fabric.Please note that the detailed outlining of the respective capabilities in SAP Datasphere can also be automatically imported via the Import Entities option if you have an SAP BW/4HANA or BW Bridge in place (please see SAP Help | Importing Data Models from SAP BW). Read More Technology Blogs by SAP articles

#SAP

#SAPTechnologyblog