WHAT-IF ANALYSIS IN OLAP - With a Case Study in Supermarket Sales Data

Emiel Caron, Hennie Daniels

2010

Abstract

Today’s OnLine Analytical Processing (OLAP) or multi-dimensional databases have limited support for whatif or sensitivity analysis. What-if analysis is the analysis of how the variation in the output of a mathematical model can be assigned to different sources of variation in the model’s input. 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 on a product’s profitability in an OLAP supermarket sales cube. In this paper, we extend the functionality of the OLAP database with what-if analysis.

References

  1. Cariou, V., Cubillé, J., Derquenne, C., Goutier, S., Guisnel, F., and Klajnmic, H. (2008). Built-in indicators to discover interesting drill paths in a cube. In DaWaK 7808: Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery, pages 33-44, Berlin, Heidelberg. Springer-Verlag.
  2. Caron, E. and Daniels, H. (2008). Extensions to the olap framework for business analysis. In ICSOFT (ISDM/ABF), pages 240-247.
  3. Caron, E. and Daniels, H. (2009). Business analysis in the olap context. In ICEIS (2), pages 325-330.
  4. Caron, E. A. M. and Daniels, H. A. M. (2007). Explanation of exceptional values in multi-dimensional business databases. European Journal of Operational Research, 188:884-897.
  5. Daniels, H. A. M. and Caron, E. A. M. (2009). Automated explanation of financial data. Intelligent Systems in Accounting, Finance & Management, 16(1-2):5-19.
  6. Han, J. and Kamber, M. (2005). Data Mining: Concepts and Techniques. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA.
  7. Lenz, H. J. and Shoshani, A. (1997). Summarizability in OLAP and statistical data bases. In Statistical and Scientific Database Management, pages 132-143.
  8. Sarawagi, S., Agrawal, R., and Megiddo, N. (1998). Discovery-driven exploration of olap data cubes. In Conf. Proc. EDBT 7898, pages 168-182, London, UK. Springer-Verlag.
Download


Paper Citation


in Harvard Style

Caron E. and Daniels H. (2010). WHAT-IF ANALYSIS IN OLAP - With a Case Study in Supermarket Sales Data . In Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-04-1, pages 208-213. DOI: 10.5220/0002897202080213


in Bibtex Style

@conference{iceis10,
author={Emiel Caron and Hennie Daniels},
title={WHAT-IF ANALYSIS IN OLAP - With a Case Study in Supermarket Sales Data},
booktitle={Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2010},
pages={208-213},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002897202080213},
isbn={978-989-8425-04-1},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - WHAT-IF ANALYSIS IN OLAP - With a Case Study in Supermarket Sales Data
SN - 978-989-8425-04-1
AU - Caron E.
AU - Daniels H.
PY - 2010
SP - 208
EP - 213
DO - 10.5220/0002897202080213