校园财务数据仓库系统的建立和OLAP应用

如何更加有效地利用事务处理系统产生的大量数据、使其发挥更大的价值，这是数据处理工怍的一个重要课题，笔者以所在学校为例讲述了校园财务数据仓库系统的建立和OLAI，应用。从数据粒度的选择、纯操作型数据的去除、模式的建立三个方面讲述了数据仓库的建模方法同时介绍了如何对多维组织后的数据进行切片、切块、聚合、钻取、旋转等操作。所介绍的方法对于在事务处理系统的基础上建立数据仓库系统、从以往的历史数据中挖掘隐藏的有价值信息,充分利用信息资源，辅助财务决策具有重要的意义。

Establishment of Financial Data Warehouse of Campus and Application of OLAP

How to use the data produced by the transaction processing system more efficiently is an important thesis in data processing. This paper introduces the building of data warehouse and the application of OLAP by a sample of the author's school .This paper discusses the method of data warehouse modeling from three prospects of the selection of data granularity, the wiping off of the pure operating data and the setting up of the OLAP modeling. At the same time, slicing,dicing,drilling,integrating and rotating to the multidimension data cube are also introduced. The method this paper discussed are very important to mining valuable information in the data warehouse based on the transaction processing system and also helpful to use the information resource fully and make the financial decision.