Types of DSO (Data Store Objects) in SAP BW/BI

Data Store Object (DSO)


Definition

• 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.

Use

Standard : Consists of three tables: activation queue, table of active data, change log

2) Possible of having Update rules

3) SID Generation for characterstics at the time of Activation

4) BEx Queries Possible

5) We can only add or overwrite the records for new data request

For direct update :  Consists of the table of active data only

2) No Possiblity of having Update rules

3) NO SID Generation for characterstics and No concept of  Activation

4) BEx Queries Possible

5) System deleted all existing records when we do new data request upload

Write-optimized :  Consists of the table of active data only

2) Possible of having Update rules

3) NO SID Generation for characterstics and No concept of  Activation

4) BEx Queries Possible

5) We can only add the records for new data request