I am implementing BI reporting for the Procurement business (Purchasing and Accounts Payables). So on the Purchasing Side, I plan on the following data warehouse model
1) EDW layer - 1st layer of ODSs with the straight mappings from the extractors - Purchasing header, purchasing item, schedule line, account assignment, requisitions etc.
2) Data mart layer - 2nd layer of ODS with PO doc no, PO item no and schedule line no as the key which combines data from the header, item and schedule line ODS into one ODS and then I will also look up other acct assignment and requisition fields from the the corresponding EDW layer ODSs in the end routine
3) Reporting Layer - InfoCubes and Multiproviders designed for reporting requirements.
What do you think? Is this the right way to go about the data model for Purchasing
Appreciate your response