Skip to Content
0
Former Member
Nov 24, 2006 at 03:41 AM

EDW Architecture question in BI 7.0

27 Views

Hi All,

In EDW architecture, we have 3 different layers

1) Staging

2) Transformation

3) Datamart Layer

Each layer has its own purpose and i would like to concentrate on a scenario.

Say Sales order header, item and schedule line are pulled from R/3 to BI.

Staged in STAGING LAYER in Data store.

Transformed in the Transformation layer in Data store/ Cube.

Created cube in the Datamart layer, created Multicubes/Infoset and Bex Reports.

This is possible because the extractors are ODS Compatible. But not all extractors are ODS Compatible.

Question

If the Extractor is not ODS compatible, how do i design something that would be in sync with the EDW Architecture ( PSA -> ODS/DATASTORE -> CUBE) ?

Reply will be greatly appreciated.

Thanks

Niveda