Skip to Content
0
Former Member
Jun 12, 2009 at 12:47 PM

EDW-Layers Implementation!!

49 Views

hello,

i have a question...

i try to modelling a data model for Sales&Distribution (SD). Now i want to implement the different Layers of the EDW-Konzept.

The Layers called:

Layer1: Data Aquisition Layer

Layer2: Enterprise Data Warehouse Layer

Layer3: Operational Data Store Layer (optional)

Layer4: Architeted Data Mart Layer

a part of my model:

Data Aquisition Layer

DSO1: Sales Order-Header Data (2LIS_11_VAHDR)

DSO2: Sales Order-Item Data (2LIS_11_VAITM)

DSO3: Order Conditions (2LIS_11_VAKON)

Enterprise Data Warehouse Layer

DSO: Sales //Merge header and item data

Architeted Data Mart Layer

InfoCube: Sales //For Reporting

the DSO2 (Sales Order-Item Data) gets data from DataSource 2LIS_11_VAITM.

But DSO2 (Sales Order-Item Data) gets the conditions information from the DSO3(Order Conditions) too.

In Books it is described, the Data Aquisition Layer is the Layer which DataSource Information will mapped 1:1 to DSO.

But the DSO2(Sales Order-Item Data) gets Information from DSO3(Order Conditions) too..

My Question

In wich Layer should i add the DSO2(Sales Order-Item Data)? Layer1 or Layer2?

regards