What is DSO in SAP BW? Why Use It?
What is DSO?
A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed transaction data or master data on a lowest granularity. DSO stands for Data Store Object.
Why use DSO?
Lets take an example of Sale order Data, which has to be extracted from SAP R/3 system(OLTP:Online Transaction Processing data which keeps changing) into BI. The Sales Orders created in the R/3 system could be edited at any point of time after creation of the record. Initially when sales order records are created in R/3, these records are extracted into BI. Once the records are changed in R/3, the changes need to be made in BI.
Types of DSO
DSOs can be classified into the following types: