About DSO:
A Data Store object (DSO) is a two dimensional stockpiling unit which for the most part stores combined and purged exchange information or expert information on a least granularity
Usage Of DSO:
Gives take a case of Sale a chance to request Data, which must be extricated from SAP R/3 system(OLTP:Online Transaction Processing information which continues changing) into BI. The Sales Orders made in the R/3 framework could be altered anytime of time after formation of the record. At first when deals request records are made in R/3, these records are extricated into BI. Once the records are changed in R/3, the progressions should be made in BI.
DSOs can be grouped into the accompanying sorts:
A Data Store object (DSO) is a two dimensional stockpiling unit which for the most part stores combined and purged exchange information or expert information on a least granularity
- It is a two dimensional Transparent Table.
- Information is put away at nitty gritty level.
- With DSO, it is additionally conceivable to overwrite information fields.
- Point by point level reporting can be gotten from a DSO.
Usage Of DSO:
Gives take a case of Sale a chance to request Data, which must be extricated from SAP R/3 system(OLTP:Online Transaction Processing information which continues changing) into BI. The Sales Orders made in the R/3 framework could be altered anytime of time after formation of the record. At first when deals request records are made in R/3, these records are extricated into BI. Once the records are changed in R/3, the progressions should be made in BI.
- Information is extricated from SAP R/3 framework and stacked into Data Store Object.
- At first, records are put away in New Status in the DSO. Records are put away in the New Table.
- Once the DSO information is enacted, information is put away in the Active table.The New Table does not hold that information any longer.
- At the point when records are changed in R/3, for these progressions to reflect in BI, the progressions are extricated into the DSO.
- Presently the information is put away in the new table until the DSO substance are initiated. The Data must be further stacked into Info shape from which reports are being conveyed.
- DSO has Overwrite and added substance functionalities.If all attributes are same, key figures are totaled/overwritten in light of the usefulness picked.
- 3D square is added substance in nature. In the event that all attributes are same, key figures are totaled.
DSOs can be grouped into the accompanying sorts:
- Standard DSO
- Direct Update DSO
- Compose Optimized DSO
