OLAP design and realization in decision support system
Yali Li
Abstract
Yali Li
Abstract
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-dimensional 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.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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-dimensional 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.
Key concepts: Online analytical processing, Data warehouse, Decision support system, Computer science, Realization (probability), Set (abstract data type), Database, Data mining