Design and Realization of College Finance OLAP Analyzer Based on MDX

  • Peng Cheng
  • Tong Qiuli
Conference paper
Part of the Advances in Intelligent and Soft Computing book series (AINSC, volume 144)


University financial data can be used to analyze university operational status and guide decision-making. In order to browse financial data from multiple dimensions, we proposed a financial analyzer based on the MDX (multidimensional expression) technology, realized querying financial data from multiple dimensions and the function of data analysis, then test the query performance of the analyzer and compared with SQL language in operation efficiency and complexity.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Shumate, J.: Practical Guide to the Microsoft Olap Server. Addison-Wesley Longman Publishing (2000)Google Scholar
  2. 2.
    Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., Laurent, D.: A personalization framework for olap queries. In: DOLAP, pp. 19–28 (2005)Google Scholar
  3. 3.
    Gunderloy, M., Sneath, T.: SQL Server Developer’s Guide to Olap with Analysis Services (Developer’s Handbook Series). In: SYBEX, pp. 240–250 (2001)Google Scholar
  4. 4.
    Harinath, S. Quinn, S.R.: Professional SQL Server Analysis Services 2005 with MDX. Hungry Minds Inc., pp. 68–73 (2005)Google Scholar
  5. 5.
    Whitehorn, M., Zare, R., Pazusmansky, M.: Problem solving for MDX for SQL Server 2005, pp. 105–131. Springer, New York (2007)Google Scholar
  6. 6.
    Morfonios, K., Konakas, S., Ioannidis, P., Kotsis, N.: ROLAP implementations of the data cube. ACM Computing Surveys (CSUR) 39, 12–15 (2007), doi:10.1145/1287620.1287623CrossRefGoogle Scholar
  7. 7.
    Kalnis, P., Papadias, D.: Multi-query optimization for on-line analytical processing. Information Systems 28, 230–234 (2003), doi:10.1016/S0306-4379(02)00026-1CrossRefGoogle Scholar
  8. 8.
    Giacometti, A., Marcel, P., Negre, E., Soulet, A.: Query recommendations for OLAP discovery driven analysis. In: Proceeding of the ACM, pp. 81–88. ACM Press (November 2009), doi:10.1145/1651291.1651306Google Scholar
  9. 9.
    Niemi, T., Nummenmaa, J., Thanisch, P.: Constructing OLAP cubes based on queries. In: Proceedings of the ACM, pp. 9–15. ACM Press (November 2001), doi:10.1145/512236.512238Google Scholar
  10. 10.
    Dehne, F., Eavis, T., Rau-Chaplin, A.: Parallel querying of ROLAP cubes in the presence of hierarchies. In: Proceedings of the 8th ACM International Workshop, pp. 89–96. ACM Press (November 2005), doi:10.1145/1097002.1097019Google Scholar
  11. 11.
    Chen, J.V.: The Perspectives of Improving Web Search Engine Quality. In: Calero, C. (ed.) Handbook of Research on Web Information Systems Quality, pp. 481–490 (2008)Google Scholar
  12. 12.
    Li, C.-H.: Application of OLAP Technology in Production Evaluation. Computing Technology and Automation 28, 133–137 (2009); 李才华. OLAP技术在生产评价中的应用[J]. 计算技术与自动化 28(4): 133–137 (2009)Google Scholar
  13. 13.
    Lan, J., Jin, H.-M.: The Design and Realization of OLAP Based Data Warehouse Analysis Model in Enterprises. Process Automation Instrumentation 27, 9–12 (2006); 蓝 箭, 金红梅. 基于OLAP的企业数据仓库分析模型设计与实现. 自动化仪表 27(5):9-12 (2006)Google Scholar
  14. 14.
    Jiang, N., Gao, W., Zhang, L.-Q.: Research and Application of Data Mining Model based on Analysis Services. Machinery Design & Manufacture 4, 83–85 (2007); 姜 楠, 高 巍, 张丽秋. 基于Analysis Services的数据挖掘模型的研究与应用. 机械设计与制造, 年4期:83–85 (2007)Google Scholar
  15. 15.
    Chen, Q.-M., He, C.-B., Liu, H.: OLAP-based collaborative educational decision. Computer Applications 29, 304–305 (2009); 陈启买, 贺超波, 刘 海. 基于OLAP的高校教学协同决策. 计算机应用 29(1): 304–305 (2009)Google Scholar

Copyright information

© Springer-Verlag GmbH Berlin Heidelberg 2012

Authors and Affiliations

  1. 1.Department of Computer Science and TechnologyTsinghua UniversityBeijingChina

Personalised recommendations