数据架构与流程：系统集成及报表处理.pdfVIP

User

WebaccessExcelaccess

Front

Endtodataandreportstodataandreports

BWReportsGMRLegalSaEtc

Data

Marts

SaProcessStockWork

DataDocOrdersMvts..etc..ordersAccounts

Warehouse

LoadingandTransformation

Extraction

Othersources:

ERPSDPP…MMFICOTIS,LIS

COOM

?+?

PCOMCO

CO-PC:CO-OM:

1.Material1.CCACostand

ledgeractualAllocation,

costing2.CCAStatisticalKey

2.Periodendfigures,

3.Planactual3.CCAActualCost

dataUsingDeltaExtraction,

4.OPAActualCost

UsingDeltaExtraction,

ArchitectureoftheDataWarehouse

BW

SDPPPMMMFICOPACOPCCOOM

4

3+4+5

1+2+31+21+2+31+21+2?+?

3

Loading

ERPExtraction

SDPPPMMMFIARGLPA