Cube and DSO Design opinion?

[Former Member]

I would like to have some opinion from the experts on the following design.I am using the 0FC_C07 cube and the 0FC_OP_01 datasource.Is it advisiable to load the data into the cube directly or use a DSO to stage the data and then move it into the infocube as there is document level data coming in and there will be approximately 3 million customer data being loaded every month.We also plan to use the BI accelerator.Any suggestion will be appreciated.

[Former Member]

The thumb rule of having a DSO in between the cube is DS, is when you want the delta coming in from the source system. As the ODS has overwrite and cube has a additive feature.

check this thread which discusses the uses of ODS:

Message was edited by:

voodi