loading data from ods to cube

10 pts.
Tags:
InfoCube
ODS (Operational Data Store)
SAP analytics and reporting
SAP BI
can u tell me y should we first load data into the ods and then into the cube?? please give examples .... If it is done in specific cases only where the need of the situation demands then please give me examples of such situations.

Answer Wiki

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

A first level ODS, you always store future objects, which you know the business might need.
A second level Cube, which have only object that business use currently. This will save time for loading.

Ex: Later on when business need to add an object that does’t exist in the Cube and also need historical data. You don’t have to run Init Set-up on R/3 side(require R/3 down time) and delete data in the cube then re-init load on BW.

Hope this help

Discuss This Question: 2  Replies

 
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
  • Gauthamyn
    ODS has overwrite functionality that can maintain unique set of key. data consistency can be maintained. wher are in the cube if v load the same data more than 3 times then from the 3rd request it allows duplicates.
    10 pointsBadges:
    report
  • Battula
    A first level ODS, you always store future objects, which you know the business might need. A second level Cube, which have only object that business use currently. This will save time for loading. Ex: Later on when business need to add an object that does't exist in the Cube and also need historical data. You don't have to run Init Set-up on R/3 side(require R/3 down time) and delete data in the cube then re-init load on BW. Hope this help
    20 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