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