BUSINESS ANALYSIS IN THE OLAP CONTEXT

Emiel Caron, Hennie Daniels

Abstract

Today's multi-dimensional business or OnLine Analytical Processing (OLAP) databases have little support for sensitivity analysis. Sensitivity analysis is the analysis of how the variation in the output of a mathematical model can be apportioned, qualitatively or quantitatively, to different sources of variation in the input of the model. This functionality would give the OLAP analyst the possibility to play with ``What if...?''-questions in an OLAP cube. For example, with questions of the form: ``What happens to an aggregated value in the dimension hierarchy if I change the value of this data cell by so much?'' These types of questions are, for example, important for managers that want to analyse the effect of changes in sales, cost, etc., on a product's profitability in an OLAP sales cube. In this paper, we describe an extension to the OnLine Analytical Processing (OLAP) framework for business analysis in the form of sensitivity analysis.

References

  1. E. Caron, H.A.M. Daniels, (2007). Explanation of exceptional values in multi-dimensional business databases. European Journal of Operational Research, 188, 884-897.
  2. J. Han and M. Kamber, (2005). Data Mining: Concepts and Techniques, San Francisco, CA, USA.
  3. H. J. Lenz, A. Shoshani, (1997). Summarizability in OLAP and statistical data bases, Statistical and Scientific Database Management, 132-143.
  4. P. A. Samuelson, (1941). The Stability of Equilibrium: Comparative Statics and Dynamics, Econometrica, 9, No 2, 97-120.
  5. S. Sarawagi, R. Agrawal, R. Megiddo, (1998). Discoverydriven exploration of OLAP data cubes, in: Conf. Proc. EDBT 7898, London, UK, pp. 168-182.
  6. J. R. Schott, (1997). Matrix analysis for statistics.
Download


Paper Citation


in Harvard Style

Caron E. and Daniels H. (2009). BUSINESS ANALYSIS IN THE OLAP CONTEXT . In Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 2: ICEIS, ISBN 978-989-8111-85-2, pages 325-330. DOI: 10.5220/0001989103250330


in Bibtex Style

@conference{iceis09,
author={Emiel Caron and Hennie Daniels},
title={BUSINESS ANALYSIS IN THE OLAP CONTEXT},
booktitle={Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 2: ICEIS,},
year={2009},
pages={325-330},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001989103250330},
isbn={978-989-8111-85-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 2: ICEIS,
TI - BUSINESS ANALYSIS IN THE OLAP CONTEXT
SN - 978-989-8111-85-2
AU - Caron E.
AU - Daniels H.
PY - 2009
SP - 325
EP - 330
DO - 10.5220/0001989103250330