基于SAP BW系统的数据仓库模型建设——数据仓库技术在电力企业ERP中的应用

Construction of Data Warehouse Model based on SAP BW System——application of Data Warehouse technology in electric power enterprise ERP

为了有效利用ERP中的海量数据,结合ERP中人力资源、财务、物资、项目、设备管理等五大核心模块的指标、维度和报表分析,构建了电力企业基于SAP BW系统的数据仓库模型架构,并在此基础上以某电力公司某年的变电所建设情况为例,五步法阐述了面向电力企业ERP的数据仓库建设过程。期望能为相关电力企业提供有价值的参考。

To apply tremendous amount of data in ERP effectively, a data warehouse mod-el architecture on the basis of SAP BW system was constructed based on the index, di-mension and report analysis of human resource, financial, material, project, and device man-agement modules of electric power enterprises. And on this basis, a power company’s con-struction of transformer substation in a certain year was taken as the example to describe the data warehouse construction process for electric power enterprise ERP. Hopefully this result can provide valuable reference for the related electric power enterprises.