Difference between Persistent Staging area and Operational Data Store to get to info cubes and reports?
Difference between Persistent Staging area and Operational Data Store to get to info cubes and reports?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 17, 2009 2:15 PM
UPDATED:
March 24, 2009 6:04 AM
Answer Wiki:
Persistant Staging area is used as a temporary space to hold data before it is loaded to the SAP BI system. As the operational system OLTP cannot be kept out of service for long, we use the PSA.
All the data in the source system is copied as it is to the PSA. Transformations are then carried out on PSA data before it gets loaded in the SAP BI system.
Operational Data Stores or DSO objects are used to store very detailed data or highly granular data.
This data is not suited for analysis or reporting unless the report requires detail data. DSOs can be used to take data from different sources and then combine them in a single DSO object. This data can then be transformed and sent to an InfoCube.
From SAP BI 7.0 onwards, it is mandatory to use PSA for loading data in the BI system.
So, these two perform different roles. PSA acts as a temporary buffer and ODS used to store granular data.
Hope that answers your question.
To see all answers submitted to the Answer Wiki: View Answer History.
Hi,
PSA is used for error handling. Before loading the data into BW system. We will move it to PSA. In case of any error occurs here we can correct the error and we can update it to data targets.
DSO is mainly used for data staging. As it is a 2 dimensinal model.
DSO detailed data is maintained where as in Cube summarised data will be maintained. So searching will be quicker and easier while generating reports on CUbes than DSO’s