Extensions to the OLAP framework for business analysis

Research output: Chapter in Book/Report/Conference proceedingConference contributionScientificpeer-review

2 Citations (Scopus)

Abstract

In this paper, we describe extensions to the OnLine Analytical Processing (OLAP) framework for business analysis. This paper is part of our continued work on extending multi-dimensional databases with novel functionality for diagnostic support and sensitivity analysis. Diagnostic support offers the manager the possibility to automatically generate explanations for exceptional cell values in an OLAP database. This functionality can be built into conventional OLAP databases using a generic explanation formalism, which supports the work of managers in diagnostic processes. The objective is the identification of specific knowledge structures and reasoning methods required to construct computerized explanations from multi-dimensional data and business models. Moreover, we study the consistency and solvability of OLAP systems. These issues are important for sensitivity analysis in OLAP databases. Often the analyst wants to know how some aggregated variable in the cube would have been change d if a certain underlying variable is increased ceteris paribus (c.p.) with one extra unit or one percent in the business model or dimension hierarchy. For such analysis it is important that the system of OLAP aggregations remains consistent after a change is induced in some variable. For instance, missing data, dependency relations, and the presence of non-linear relations in the business model can cause a system to become inconsistent.
Original languageEnglish
Title of host publicationProceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT)
EditorsJ. Cordeiro, A. Ranchordas
Place of PublicationBerlin
PublisherSpringer Verlag
Pages240-247
ISBN (Print)9789898111531
Publication statusPublished - 2008

Fingerprint Dive into the research topics of 'Extensions to the OLAP framework for business analysis'. Together they form a unique fingerprint.

  • Cite this

    Caron, E. A. M., & Daniëls, H. A. M. (2008). Extensions to the OLAP framework for business analysis. In J. Cordeiro, & A. Ranchordas (Eds.), Proceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT) (pp. 240-247). Springer Verlag.