EXTENSIONS TO THE OLAP FRAMEWORK FOR BUSINESS ANALYSIS

Emiel Caron, Hennie Daniels

2008

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 changed 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.

Paper Citation

in Harvard Style

Caron E. and Daniels H. (2008). EXTENSIONS TO THE OLAP FRAMEWORK FOR BUSINESS ANALYSIS . In Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT, ISBN 978-989-8111-53-1, pages 240-247. DOI: 10.5220/0001895102400247

in Bibtex Style

@conference{icsoft08,
author={Emiel Caron and Hennie Daniels},
title={EXTENSIONS TO THE OLAP FRAMEWORK FOR BUSINESS ANALYSIS},
booktitle={Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT,},
year={2008},
pages={240-247},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001895102400247},
isbn={978-989-8111-53-1},
}

in EndNote Style

TY - CONF
JO - Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT,
TI - EXTENSIONS TO THE OLAP FRAMEWORK FOR BUSINESS ANALYSIS
SN - 978-989-8111-53-1
AU - Caron E.
AU - Daniels H.
PY - 2008
SP - 240
EP - 247
DO - 10.5220/0001895102400247