决策支持系统中OLAP的设计与实现

OLAP design and realization in decision support system

目的设计和实现对数据仓库中的信息进行决策分析的OLAP。方法以零售企业销售预测为切入点,研究决策支持系统中OLAP的设计。结果建立了用来进行OLAP分析的多维数据集,并对多维数据集中的数据用切片、切块、钻取和旋转等方式进行分析,用MDX多维查询语言对多维数据集中的数据进行复杂查询,提出了对OLAP分析数据展现的3种解决方案。结论在研究决策支持系统中OLAP的基础上,建立和实现了对数据仓库进行决策分析的OLAP。

Aim The purpose of the article is to design and realize OLAP which can analyze the information in data warehouse for decision. Methods Taking the retail enterprise sales forecasting as starting point, OLAP projects in decision support system are planned. Results The multi-dimension- al data set for OLAP analysis is built. After researching it by slice, dice, drill and rotation enquiring it in multi-dimensional query language MDX, the three solutions which can unfold OLAP analysis data are put forward. Conclusion OLAP which can analyze the information in data warehouse for decision is designed and realized on the basis of research into OLAP in decision support system.