Datastore Objects (DSO ) in SAP BI

A DataStore object serves as a storage location for consolidated and cleansed transaction data or master data on a document (atomic) level.

This data can be evaluated using a BEx query.

A DataStore object contains key fields (such as document number, document item) and data fields that, in addition to key figures, can also contain character fields (such as order status, customer). The data from a DataStore object can be updated with a delta update into InfoCubes (standard) and/or other DataStore objects or master data tables (attributes or texts) in the same system or across different systems.

Unlike multidimensional data storage using InfoCubes, the data in DataStore objects is stored in transparent, flat database tables. The system does not create fact tables or dimension tables.

DataStore object types:
Standard DataStore object

Data provided using a data transfer process
SID values can be generated
Data records with the same key are aggregated during activation
Data is available for reporting after activation

Write-optimized DataStore object

Data provided using a data transfer process
SID values cannot be generated
Records with the same key are not aggregated
Data is available for reporting immediately after it is loaded

DataStore object for direct update

Data provided using APIs
SIDs cannot be generated
Records with the same key are not aggregated

Leave a Comment