Multidimensional query and analysis system of college finance

PENG Cheng,TONG Qiu-li
DOI: https://doi.org/10.16208/j.issn1000-7024.2012.05.066
2012-01-01
Abstract: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 decision.
What problem does this paper attempt to address?