论文标题:数据仓库在财务分析中的应用
Agriculture: Liberalization or Protection
论文作者 刘莎莎
论文导师 卢秉亮,论文学位 硕士,论文专业 企业管理
论文单位 东北财经大学,点击次数 128,论文页数 44页File Size4001k
2004-12-01论文网 http://www.lw23.com/lunwen_68199222/ 数据仓库;联机分析处理;财务报表;财务分析
DW; OALP; FINANCIAL DATA; FINANCIAL ANALYSIS
数据仓库和OLAP是最近十年发展起来的决策支持研究方向。它们可以为财务管理提供包括财务收益率、现金流量、资产管理等业务的综合分析,多维视图图表、分析报告、建立“what-if”分析及模拟最佳和最差案例情景等。本文通过以下三个主要部分的介绍,对数据仓库技术进行了比较全面的研究与应用。 第一部分:本文在考察国内外财务信息化的现状和特点的基础上,结合数据仓库的特点,分析了使用数据仓库来为决策提供支持的重要性。 第二部分:进行财务分析数据仓库的数据集市的设计和创建。首先是需求分析,采用财务分析方法确定了系统实现的决策类型,然后设计了财务报表多维分析的E-R图、事实表模型、维模型等。 第三部分:进行财务多维数据集的OLAP操作。首先是对OLAP的多维数据结构进行设计,包括维度和多维数据集的设计,然后创建维度和多维数据集,系统采用Analysis Service作为多维分析服务器,实现了从不同角度、不同维度对企业财务报表进行分析评价。
DW and OLAP technology are the new orientation of the support decision research which brought about only recent 10 years. They can support for the finance management of the inside offering includes financial income rate, cash discharge, property management etc. The multi-dimensional much sees the diagram chart, analyze the report and establish" assumption" analyze and imitate the best with most bad the case a scene waits this text passes. Through three parts, this context introducedthe warehouse technique ,and proceeded some complete study.The first part: On the basis of the investigation of the present condition and the characteristics of the domestic and international finance information, with the foundation top of the characteristics, this text analyzed the importence of using data warehouse to provide the support for the decision.The second part: Proceeding the design of the financial data system of the multi-dimensional analysis. First to design the construction of the multi-dimensional, adopt financial analysis method to confirm the type of the system. Secondly, designed the diagram of E- R, fact tables, the multi-dimensional model etc..The third part: Proceeding the operation of financial data of the multi-dimensional analysis. First, design to the OLAP of the multi-dimensional data construction, including a different from the the multi-dimensional data gather, then create to set up the degree of the multi-dimensional data, with the adoption of Analysis Service which used as the multi-dimensional analysis server. It realizes the analysis evaluation to the business enterprise financial report from different sides and degree.
|
