Aug

21

2019

What is Standard DSO in SAP-BI/BW

Laser 21 Aug 2019 03:45 LEARNING » e-learning - Tutorial

What is Standard DSO in SAP-BI/BW
What is Standard DSO in SAP-BI/BW
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3.5 Hours | Lec: 10 | 2.55 GB
Genre: eLearning | Language: English

step-by-step procedure for beginners to create standard 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.

step-by-step procedure for beginners to create standard DSO
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.
It is a two dimensional Transparent Table.
Data is stored at detailed level.
With DSO, it is also possible to overwrite data fields.
Detailed level reporting can be obtained from a DSO.
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.
Data is extracted from SAP R/3 system and loaded into Data Store Object.
Initially, records are stored in New Status in the DSO. Records are stored in the New Table.
Once the DSO data is activated, data is stored in the Active table.The New Table does not hold that data anymore.
When records are changed in R/3, for these changes to reflect in BI, the changes are extracted into the DSO.
Now the data is stored in the new table until the DSO contents are activated. The Data has to be further loaded into Info cube from which reports are being delivered.
DSO has Overwrite and additive functionalities.If all characteristics are same, key figures are aggregated/overwritten based on the functionality chosen.
Cube is additive in nature. If all characteristics are same, key figures are aggregated.
Types of DSO
DSOs can be classified into the following types:
Standard DSO
Direct Update DSO
Write-Optimized DSO

DOWNLOAD
uploadgig



rapidgator


nitroflare

High Speed Download

Add Comment

  • People and smileys emojis
    Animals and nature emojis
    Food and drinks emojis
    Activities emojis
    Travelling and places emojis
    Objects emojis
    Symbols emojis
    Flags emojis