面對全球化與競爭日益激烈的經營環境，傳統的交易處理系統與管理資訊系統已無法滿足企業的需求，現代的管理者需要以各種不同的角度與分析方法剖析資料，以協助其瞭解目前企業營運狀況與制訂決策等相關管理活動。上述原因使得決策支援系統、高階主管資訊系統、資料倉儲與線上分析處理等資訊系統蓬勃發展。建構資料倉儲與線上分析處理是昂貴且高風險的，企業建置資料倉儲與線上分析處理失敗的主要原因之一發生在需求分析階段，亦即分析線上分析處理所需的維度與階層關係。當需求擷取不完整亦或是使用者需求改變時，系統開發者必須修改或重新建構維度與階層關係以滿足使用者需求，這對系統開發人員而言是極大的負擔。雖然許多線上分析處理軟體工具均具備彈性，讓使用者可以選擇預先定義之維度與階層關係以產生分析報表。然而，對於建立線上分析處理之彈性報表設計方法論仍是缺乏的。
有鑑於此，本論文提出線上分析處理之彈性報表設計方法論，此方法論將線上分析處理所需的維度與階層關係，以視覺化的報表樣版類型與報表樣版方式呈現，以幫助使用者建立分析報表。以此方法論建構之報表樣版類型與報表樣版除了包含線上分析處理所需的維度與階層關係之外亦具備彈性報表能力，使用者可以選擇適當的報表樣版類型與報表樣版彈性產出報表，以滿足其突發性之資訊需求。

Due to the increasing global competition in today’s business environment, current Transaction Processing Systems and Management Information Systems can no longer satisfy the enterprise’s needs. Mangers need to analyze data from different views to recognizing business status, making decisions, and setting up the policies. To support such works, many information systems and technologies are developed including Decision Support Systems, Executive Information Systems, data warehouses, and On-Line Analytical Processing (OLAP). The implementation of OLAP and data warehousing project are expensive and risky. The results of implementing OLAP and data warehousing in most of the organizations do not, however, always prove a success. The common problem occurs in the requirement analysis phase when analyzing the dimensions and hierarchical relationships for OLAP. The user requirement can not be defined completely and the developers often need to modify or reconstruct the dimensions and hierarchical relationships to meet the user’s changing needs. This is an enormous burden to the system developers. Although many tools with OLAP provide the flexibility for user creating analytical reports by using predefined dimensions and hierarchical relationships. However, a methodology for designing flexible report for OLAP to support ad hoc analysis is still lacking.
This study proposes a methodology that is developed for designing flexible report for OLAP, which presents the dimensions and hierarchical relationships by visualized meta-templates and templates to help users create analysis reports. The methodology provides the flexibility not only in representing dimensions and hierarchical relationships for OLAP, but also in producing flexible reports. With such flexibility, the users can create analytical reports to support ad hoc analysis by choosing appropriated meta-template and template easily.

第一章 緒論 1
第一節 研究背景與動機 1
第二節 研究目的 3
第三節 研究方法與流程 4
第四節 研究範圍與限制 5
第五節 論文架構 6
第六節 結語 7
第二章 文獻探討 8
第一節 資料倉儲 8
第二節 作業資料儲存庫 10
第三節 線上分析處理 11
第四節 報表特性 13
第五節 正規化及語意圖形 21
第六節 資訊系統架構 25
第七節 結語 26
第三章 彈性報表設計方法論：以報表為基礎的方法 27
第一節 報表的分解與合成程序 28
第二節 報表樣版設計 31
第三節 個案應用 37
第四節 結語 43
第四章 彈性報表設計方法論：以資料庫綱目為基礎的方法 44
第一節 關聯式資料庫語意圖形建構 45
第二節 報表樣版類型與維度設計 49
第三節 表頭項目結構與階層設計 52
第四節 結語 64
第五章 線上分析處理架構與個案應用 65
第一節 線上分析處理系統架構 65
第二節 進銷存管理系統個案應用 70
第三節 實例展示 85
第四節 結語 95
第六章 結論與討論 96
第一節 研究成果 96
第二節 研究貢獻 97
第三節 報表樣版與線上分析處理維度階層關係 98
第四節 後續研究方向 100
參考文獻 101
附錄：進銷存管理系統資料庫綱目 108

中文部分
吳仁和, 統計決策支援系統之概念與應用－以臺灣省政府為例, 工業工程學刊, Vol. 13, No. 3, 1996, pp.203-213.
吳仁和與林信惠, 系統分析與設計：理論與實務應用, 第三版，智勝文化, 2004.
呂德財與莊宗岸, 管理資訊系統實務, 松崗電腦, 1999.
林三順, 政府統計作業資訊系統：彈性資訊展示設計方法之研究與應用, 中山大學資訊管理研究所碩士論文, 1998.
林宏諭, SQL2000之決策分析：OLAP建置與應用, 博碩文化, 台北, 2001.
蘇志青, 組織內一個整合統計分析資料來源的模式, 交通大學經營管理研究所博士論文, 2000.

英文部分
Angelaccio, M., Catarci, T., and Santucci, G. “QBD*: A Graphical Query Language with Recursion,” IEEE Transactions on Software Engineering, Vol. 16, No. 10, October 1990, pp.1150-1163.
Atzeni, P. and De Antonellis, V. Relational Database Theory, The Benjamin/Cummings Publishing Company, 1993.
Ausiello, G., D’atri, A. and Sacca, D. “Graph Algorithms for Functional Dependency Manipulation,” Journal of the Association for Computing Machinery, Vol. 30, No, 4, October 1983, pp. 752-766.
Batini, C., Demo, B. and Di Leva, A. “A Methodology for Conceptual Design of Office Data Bases,” Information Systems, Vol. 9, No. 3/4, 1984, 251-263.
Brachman, R. J., Khabaza, T., Kloesgen, W., Piatetsky-Shapiro, G. and Simoudis, E. “Mining Business Databases,” Communications of the ACM, Vol. 39, No. 11, 1996, pp.42-48.
Catarci, T., Chang, S.-K., Costabile, M. F., Levialdi, S. and Santucci, G. “A Graph-Based Framework for Multiparadigmatic Visual Access to Databases,” IEEE Transactions on Knowledge and Data Engineering, Vol. 8, No. 3, June 1996, pp.455-475.
Catarci, T., Costabile, M. F., Levialdi, S. and Batini, C. “Visual Query Systems for Databases: A Survey,” Journal of Visual Languages and Computing, Vol. 8, 1997, 215-260.
Chaudhuri, S. and Dayal, U. “An Overview of Data Warehouse and OLAP Technology,” ACM SIGMOD Record, Vol. 26, No. 1, March 1997, pp.65-74.
Chiang, R. H. L., Barron, T. M. and Storey, V. C. “Reverse engineering of relational databases: Extraction of an EER model from a relational database,” Data and Knowledge Engineering, Vol. 12, 1994, pp.107-142.
Chin, F. Y. and Ozsoyoglu, G. “Statistical Database Design,” ACM Transactions on Database Systems, Vol. 6, No. 1, 1981, pp.113-139.
Choobineh, J. and Mannino, M. V. and Tseng, V. P. “A Form-Based Approach for Database Analysis and Design,” Communications of the ACM, Vol. 35, No. 2, February 1992, 108-120.
Choobineh, J. and Venkatraman, S. S. “A Methodology and Tools for Derivation of Functional Dependencies from Business Form,” Information Systems, Vol. 17, No. 3, 1992, 269-282.
Choobineh, J., Mannino, M. V., Nunamaker, J. F. and Konsynski, B. R. “An Expert Database Design System Based on Analysis of Forms,” IEEE Transactions on Software Engineering, Vol. 14, No. 2, February 1988, 242-253.
Chu, W. W., Yang, H., Chiang, K., Minock, M., Chow, G. and Larson, C. “Cobase: A scalable and extensible cooperative information system,” Journal of Intelligent Information Systems, 1996.
Codd., E. F. “Providing OLAP (on-line analytical processing) to user-analysts: An IT mandate,” Technical report, E. F. Codd and Associates, 1993.
Date, C. J. An Introduction to Database Systems, Addison Wesley Longman, 2000.
Fayyad, U., Piatetsky-Shapiro, G. and Smyth, P. “The KDD Process for Extracting Useful Knowledge from Volumes of Data,” Communications of the ACM, Vol. 39, No. 11, 1996, pp.27-34.
Garnto, C. and Watson, H. J. “An Investigation of Database Requirements for Institutional and Ad Hoc DSS,” Data Base, Vol. 16, No.4, 1985, pp.3-9.
Golfarelli, M. and Rizzi, S. “Designing the data warehouse: key steps and crucial issues,” Journal of Computer Science and Information Management, Vol.2, No.1, 1999, pp.1-14.
Golfarelli, M., Maio, D. and Rizzi, S. “Conceptual design of data warehousing from E/R schemes,” Proceedings of 31st Hawaii International Conference on System Sciences, 1998.
Golfarelli, M., Maio, D. and Rizzi, S. “The Dimensional Fact Model: a Conceptual Model for Data Warehouses,” International Journal of Cooperative Information Systems, Vol.7, No.2, 1998, pp.215-247.
Golfarelli, M., Maio, D. and Rizzi, S. “The Dimensional Fact Model: A Conceptual Model for Data Warehouses,” International Journal of Cooperative Information Systems, Vol. 7, No. 2-3, 1998, pp.215-247.
Gray, J., Bosworth, A., Layman, A. and Pirahesh, H. “Data cube: A relational aggregation operator generalizing groupby, cross-tab, and sub-total,” Proceedings of the Twelfth IEEE International Conference on Data Engineering, 1995, pp. 152-159.
Gray, P. and Watson, H. J. “Present and Future Directions in Data Warehousing,” The Data Base for Advances in Information Systems, Vol. 29, No. 3, 1998, pp.83-90.
Gray, P. and Watson, H. J. Decision Support in the Data Warehouse, Prentice Hall, 1998.
Holsapple, C. W. and Whinston, A. B. “Decision Support Systems: A Knowledge-based Approach,” West Publishing Co. St. Paul, MN, 1996.
Hsieh, C. H. and Jan, T. S. “Reorganization of Historical Data to Support the Analysis of Organization’s Behavior,” IEEE Transactions on systems, man and cybernetics, Vol. 19, No. 1, 1989, pp.153-158.
Inmon, W. H. Building the Operational Data Store, John Wiley & Sons, 1999.
Inmon, W. H. and Hackathorn, R. D. Using the Data Warehouse, John Wiley & Sons, 1994.
Inmon, W. H., Imhoff, C. and Battas, G. Building the Operational Data Store, John Wiley & Sons, 1996.
Isakowitz, T., Shocken, S. and Lucas, Jr. H. C. “Toward a Logical/ Physical Theory of Spreadsheet Modeling,” ACM Transactions on Information Systems, Vol. 13, No. 1, January 1995, 1-37.
Kelly, S. Data Warehousing in Action, John Wiley & Sons, 1997.
Kimball, R. and Ross, M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley & Sons, 2002.
Lehner, W., Albrecht, J. and Wedekind, H. “Normal Forms for Multidimensional Database,” Proceedings of 10th International Conference on Statistical and Scientific Database Management, 1998, pp.63-72.
Lenz, H. J. and Shoshani, A. “Summarizability in OLAP and Statistical Data Bases,” Proceedings of 9th International Conference on Statistical and Scientific Database Management, 1997, pp.132-143.
Nunamaker, J. F., Jr, Chen, M. and Prudin, D. M. “Systems Development in Information Systems Research,” Journal of Management Information Systems, Vol. 7, No. 3, Winter 1990-1991, pp.89-106.
Orli, R. J. “Modeling Data for the Summary DataBase,” Data Base, Spring 1990, pp.11-19.
Pedersen, T. B. and Jensen, C. S. “Multidimensional data modeling for complex data,” Proceedings of 15th International Conference on Data Engineering, IEEE Computer Society, 1999, pp.336-345.
Ram, S. and Shankaranarayanan, G. “Modeling and Navigation of Large Information Spaces: A Semantics Based Approach,” Proceedings of the 32nd Hawaii International Conference on System Sciences, 1999.
Shu, N. C. “FORMAL: A Form-Oriented, Visual-Directed Application Development System,” Computer, 1985, 38-49.
Shu, N. C., Lum, V. Y., Tung, F. C. and Chang, C. L. “Specification of Forms Processing and Business Procedures for Office Automation,” IEEE Transactions on Software Engineering, Vol. SE-8, No. 5, September 1982, 499-512.
Singh, H. S. Data Warehousing: Concept, Technologies, Implementations, and Management, Prentice Hall, 1998.
Ssmar, R. Z., Xin, M. and Han, J. “Discovering Web Access Patterns and Trends by Applying OLAP and Data Mining Technology on Web Logs,” Proceedings of the IEEE International Conference on Research and Technology Advances in Digital Libraries, 1998, pp.19-29.
Teorey, T. J., Yang, D. and Fry, J. P. “A logical design methodology for relational databases using the extended entity-relationship model,” ACM Computing Surveys, Vol. 18, No. 2, 1986, pp.197-222.
Thomsen, E. OLAP Solutions: Building Multidimensional Information Systems, John Wiley & Sons, 2002.
Trujillo, J. C. and Palomar, M. “An Object-Oriented Approach to Multi-dimensional Database Conceptual Modeling,” Proceedings of the ACM 1st International Workshop on Data Warehousing and OLAP, Washington D.C., USA, 1998.
Tryfona, N., Busborg, F. and Christiansen, J. G. B. “starER: A conceptual model for data warehouse design,” Proceedings of ACM 2nd International Workshop on Data Warehousing and OLAP , Kansas City, USA, 1999.
Tsichritzis, D. “Form Management,” Communications of the ACM, Vol. 25, No. 5, July 1982, 453-478.
Vassiliadis, P. and Sellis, T. “A survey of logical models for olap databases,” SIGMOD Record, Vol. 28, No.4, December 1999.
Vassiliadis, P. “Modeling Multidimensional Databases, Cubes and Cube operations,” Proceedings of 10th International Conference on Scientific and Statistical Database Management, IEEE Computer Society, 1998.
Watson, H. J. and Haley, B. J. “Data Warehousing: A Framework and Survey of Current Practices,” Journal of Data Warehousing, Vol. 2, No. 1, 1997, pp. 10-17.
Wixom, B. H. and Watson, H. J. “An Empirical Investigation of the Factors Affecting Data Warehousing Success,” MIS Quarterly, Vol. 25, No. 1, March 2001, pp. 17-41.
Wu, J. H., Doong, H. S., Lee, C. C., Hsia, T. C. and Liang, T. P. “A Methodology for Designing Form-based Decision Support Systems, Volume 36, Issue 3, January 2004, pp. 313-335.
Wu, J. H. "A Visual Approach to End User Form Management," Journal of Computer Information Systems, Vol. XXXXI, No. 1, Fall 2000, pp. 31-39.
Yao, S. B., Hevner, A. R., Shi, Z. and Luo, D. “FORMANAGER: An Office Forms Management System,” ACM Transactions on Office Information Systems, Vol. 2, No. 3, July 1984, 235-262.
Zhang, G., Chu, W. W., Meng, F. and Kong, G. “Query Formulation form High-level Concepts for Relational Databases,” Proceedings of User Interfaces to Data Intensive Systems, September 1999, pp.64-74.