Difference between Persistent Staging area and Operational Data Store to get to info cubes and reports?

5 pts.
Tags:
InfoCube
SAP BI
SAP BI BW
SAP BW
Difference between Persistent Staging area and Operational Data Store to get to info cubes and reports?
ASKED: January 17, 2009  2:15 PM
UPDATED: March 24, 2009  6:04 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • aakashg
    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  
    35 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following