SAP BI/BW WHAT IS DSO AND IT TYPES AND DIFFERENCES ?

Definition :

A data store object is used to store consolidated and cleansed data on a document level.

Usage :

Overwrite Functionality.Designed to save cleansed data.

Types :

1. Standard DSO.
2. Write-Optimized DSO.
3. Direct update DSO.

Differences :

Standard DSO :

    1.Consists of 3 tables 

      Activation queue(New Data Table) : Used to hold the records that are to be updated before activation.                                              
     Active Data : Used to hold the data records after activation.
     Change Log : Used to hold the  change history of delta records.
 
     2. Possible of having update rules.
     3. SID generation for characteristics at the time of activation.
     4. Bex queries possible.
     5. We can only add or overwrite the records for new data request.
     6. Data records with the same key are aggregated during activation.
     7. Data is available for reporting after activation.
     8. Data provided to this dso using data transfer process.
     9. Delta mechanism is possible.
   10.Over write functionality.

Write-Optimized  DSO :

1. Consists of active data table only.
2. Possible of having update rules.
3. SID values cannot be generated bcoz there is no concept of activation.
4. Bex queries  possible.
5. We can only add the records for a new data request.
6. Data records with the same key are not aggregated.
7. Data is available for reporting after it is loaded.
8. Data provided using the data transfer process.
9. Delta supported based on the  request number.
10. No over write functionality.

Direct Update DSO :

1. Consists of active data table only.
2. No possibilty of having update rules.
3. SID values cannot be generated.
4. Bex queries possible.
5. We can over write the data for new data request.
6. Data records with the same key are not aggregated.
7. Data is available for reporting after it is loaded.
8. Data provided to this dso using API's.
9. Full update only.
10. Over write functionality.