ADSO
The Advanced DataStore Object (ADSO) is the core BW/4HANA and BW-on-HANA data persistence and modeling object that replaced classic DataStore Objects and InfoCubes for most scenarios. This topic covers ADSO purpose, types, activation logic, key/data fields design, transformation and DTP integration, reporting exposure, performance tuning and troubleshooting, and how ADSO behavior differs across BW7.x on HANA, BW/4HANA and embedded analytics contexts.
Overview
The Advanced DataStore Object (ADSO) is the core BW/4HANA and BW-on-HANA data persistence and modeling object that replaced classic DataStore Objects and InfoCubes for most scenarios. This topic covers ADSO purpose, types, activation logic, key/data fields design, transformation and DTP integration, reporting exposure, performance tuning and troubleshooting, and how ADSO behavior differs across BW7.x on HANA, BW/4HANA and embedded analytics contexts.
Lessons in this topic
- ADSO Activation, Change Log, and Delta Handling for Downstream ConsumersUnderstand how ADSO activation moves data from the inbound (new data) table to the active table, how the change log records deltas, and how downstream transformations and queries consume that delta correctly.
- ADSO Design: Keys, Activation, Delta Handling, and Change Log BehaviorLearn how to design ADSO semantic keys, understand the activation process, and configure delta and change-log behavior correctly for reliable production loads.
- ADSO Fundamentals: What It Is and Why It Replaced Classic BW ObjectsUnderstand what an Advanced DataStore Object (ADSO) is, why SAP introduced it, and the different ADSO types you will configure in real BW/4HANA projects.
- What Is an ADSO and Why It Replaced Classic BW Data TargetsUnderstand what an Advanced DataStore Object is, why SAP introduced it, and how it consolidates the roles of classic DSOs, InfoCubes and PSA-like staging in a single flexible object.
- ADSO Activation, Request Processing, and Performance TuningUnderstand what happens technically when data is loaded into an ADSO and activated, how requests move through the inbound, active, and change log tables, and how to diagnose and tune slow activation or reporting performance.
- Designing ADSO Types, Key Fields and Activation BehaviorLearn how to choose the right ADSO type for staging versus reporting, design key and data fields correctly, and understand the activation and delta process that moves data between internal tables.