Skip to Content
Former Member
Mar 17, 2008 at 08:44 AM

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?