To query financial data from multiple dimensions, support analysis and decision, a financial analyzer based on the MDX (multidimensional expression) technology is presented to realize the function of establishing multidimensional data set from source database, querying financial data from multiple dimensions based on MDX, and analysis of result data. To assist management and support decision making, modules are designed on saving results in Excel, user and group management, permission settings, table nickname settings, etc. Finally, a case study of query is presented to compare with SQL, results indicate the proposed analyzer is better in efficiency and help decisioa%为了能够从多个角度查询财务数据,以支持分析和决策,提出了基于MDX(多维表达式)技术的财务分析器,实现从源数据库建立多维数据集,并利用MDX技术从多个维度查询财务数据,以及对结果进行数据分析的功能.在此基础上实现了结果导出Excel、用户和组管理、可访问数据库设置、表项别称设定等模块,以帮助管理、使用和支持决策.并通过实例测试与传统SQL查询进行比较,结果表明该分析器在效率上更加优秀且更适合于帮助分析决策.
展开▼
