Skip to Content
author's profile photo Former Member
Former Member

core data warehouse-component in SAP BW

Hi experts,

a typical data warehouse reference architecture (as described in many books) basically consists of a core data warehouse, an ods and data marts.

As far as I understood in SAP BW an ODS object acts as a storage location for consolidated and cleaned-up transaction data (transaction data or master data, for example) on the document (atomic) level. This data is not stored permanently but overritten as soon as changes are applied to data in the operational systems.

But where in SAP BW is a component like a core data warehouse that stores consolidated and cleaned-up transaction data on atomic level permanently without overwriting it????

Thanx

Axel

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 08:20 AM

    Hi Axel,

    I guess pizzaman was refering to this PDF:

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5586d290-0201-0010-b19e-a8b8b91207b8

    You can refer from page 17 onwards.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hello all,

      I 've come to the conclusion that Pizzaman is right. The "core data warehouse" or "Data Warehouse Layer" (in SAP terms) consists of different levels of ODS-Objects (with the second ODS-layer holding persistent granular data) and Master Data as shown on page 22 of PDF.

      Thanx to Pizzaman

      Thanx to Dinesh

      Axel

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 09:16 PM

    That would be a Cube. You cannot overwrite any data in the cube. ODS is usually used to check if the data that is being collected is the correct data and free of any errors. Then it is loaded into a Cube. You can run queries on that cube and get the required data.

    Hope that answers your question.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 01:23 PM

    Might want to review the Modleing the Data Warehouse Layer with BI article on this page

    BI Data Modeling and Frontend Design [original link is broken]

    As to slide 20, (BW 3.5 = NW 2004, BI 7.0 = NW 2004s) , you can implement the this approach in 3.5, there's nothing new in NW 2004s that provides this, it is a desing approach. 2004s does change the terminology a bit, and has reworked the ETL side of things and added the Transational Data Store, all of which helps implement this new layered approach, but I don't think think the delivered Business Content has really caught up with the idea - perhaps with newer modules.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.