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

BW Backend design issue

Hi all,

We use 2 layers in BW.In the first layer we have 3 ODS which gives data to 3 corresponding cubes.Then these 3 cubes of the first layer gives data to corresponding 3 cubes of the second layer.This is the structure we follow.

Now they have come up with a new structure saying we can do away with the cubes in lower layer and just have 3 ODS in the first layer and corresponding 3 cubes in the second layer

Also only the cubes in the 2nd layer are used for reporting always.

Can someone tell me the pros and cons of both of these structures?

How will the second approach help?

Regards,

Suchitra

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 17, 2008 at 09:01 AM

    In the first structure, the intermediate layer of cubes is unnecessary as it will increase your loading activities & subsequently the system load.

    Getting rid off this layer in second structure is ideal & reporting is based on cube as the run time performance of the query will be better on cubes instead of ODSes.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2008 at 01:12 PM

    Hi Suchitra,

    The Best Practices are as below.

    1. Have a first level DSO / ODS layer where the complete Dataset is brought in.

    2. Have second level DSO / ODS layer where you can have Business Specific Data.

    3. Then comes the InfoCube layer for consolidating the Data and also for Reporting.

    4. Some clients use a MultiProvider for all their reporting needs as there may be a Business Scenario or situation where you may have to pick data from different InfoProviders.

    You can correlate the above steps with your structure and decide on the suitable one.

    Hope this helps.

    Regards,

    Tom.

    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.