Return to search

A Methodology for Designing Flexible Report for On-Line Analytical Processing

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.

Identiferoai:union.ndltd.org:NSYSU/oai:NSYSU:etd-0127104-143023
Date27 January 2004
CreatorsHsia, Tse-Chih
ContributorsChun-Fu Hou, Ing-Long Wu, Jen-Her Wu, Chien-Hsing Wu, Shan-Chung Chao
PublisherNSYSU
Source SetsNSYSU Electronic Thesis and Dissertation Archive
LanguageCholon
Detected LanguageEnglish
Typetext
Formatapplication/pdf
Sourcehttp://etd.lib.nsysu.edu.tw/ETD-db/ETD-search/view_etd?URN=etd-0127104-143023
Rightswithheld, Copyright information available at source archive

Page generated in 0.0018 seconds