Blogs / SAP / SAP BW/HANA / SAP BW/4HANA / B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Jun 6, 2019

SHARE

Advanced DSO (ADSO) is the primary artifact for persisting data in SAP BW 7.4 onwards. It combines functions from the Infocube/DSO and provides further enhancements such as modeling on Infoobjects as well on simple fields.

Till B4HANA 1.0, ADSO model types were determined by selecting the appropriate settings shown in the below image. In addition to that, SAP provided predefined templates which when chosen, the settings will get adjusted accordingly.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

In B4HANA 2.0, the modeling screen has undergone a change. Our blog discusses each ADSO types in detail and the corresponding setting that needs to be chosen in B4HANA1.0 and B4HANA 2.0.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Data acquisition layer (including corporate memory) / Write optimized DSO

This is similar to the write optimized DSO which contains only the inbound/new table and no change log or active table. You can use this ADSO as the staging area in your data warehouse model.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Corporate memory – compression capabilities

Corporate memory enables you to store the entire history of the data for reconstruction purposes, without the need to extract it from the source system. ADSO also enables you to compress this data, thereby reducing the overall data footprint. However, you will not be able to trace the record back to its load after enabling this option.

This ADSO contains the inbound and active table and upon activation, data in the inbound table is cleared and the active table gets compressed by aggregating record based on their semantic key, which is basically overwriting the previous record with the value present in current load. For key figures, the aggregation depends on the type (Overwrite/Summation) selected in the transformation.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Corporate memory – reporting capabilities

The only difference between this ADSO and the one above is that after activation, data remains in the inbound table. This will enable you to trace records back to their corresponding source data loads.

Data is extracted from the inbound table and reporting is done on the active table.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Data warehouse layer – delta calculation / Standard DSO

This setting will enable the ADSO to behave like a Standard DSO, which means it will have a Change log table for delta extraction, Inbound/New table and active table for reporting and full load.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Data warehouse layer – data mart

The data mart option enables the ADSO to behave just like an Infocube, it does not have any Changelog. The inbound table acts like an “F table” and active table acts like the “E table” for compressed data. Upon activation of the request, the inbound table is cleared.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Planning on Infocube – like

This ADSO is modeled like the Data mart ADSO. It has an Inbound table and active table. All characteristics are marked as key fields in the active table which is a necessary requirement for planning.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Planning on Direct Update

This setting allows planning on a direct update ADSO. Data is loaded directly into the active table using DTP or an API. This DSO has an overwrite option unlike the Planning on Infocube model which avoids duplicate records.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Inventory

In order to use non-cumulative key figures, we must select “Inventory-Enabled” setting on the ADSO. As of now, this is supported for Standard ADSO’s and cube type ADSO’s.

B4HANA 1.0 Vs B4HANA 2.0: ADSO Modelling Properties

Know more about our SAP BW Services offerings here.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!