loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Emiel Caron 1 and Hennie Daniels 2

Affiliations: 1 Erasmus University Rotterdam, Netherlands ; 2 Tilburg University; Erasmus University, Netherlands

Keyword(s): Business intelligence, Multi-dimensional databases, OLAP, What-if analysis, Sensitivity analysis.

Related Ontology Subjects/Areas/Topics: Artificial Intelligence ; Artificial Intelligence and Decision Support Systems ; Biomedical Engineering ; Business Analytics ; Data Engineering ; Data Mining ; Data Warehouses and OLAP ; Databases and Information Systems Integration ; Datamining ; Enterprise Information Systems ; Health Information Systems ; Sensor Networks ; Signal Processing ; Soft Computing ; Strategic Decision Support Systems

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.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 44.205.5.65

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 3: ICEIS; ISBN 978-989-8425-04-1; ISSN 2184-4992, SciTePress, pages 208-213. DOI: 10.5220/0002897202080213

@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 3: ICEIS},
year={2010},
pages={208-213},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002897202080213},
isbn={978-989-8425-04-1},
issn={2184-4992},
}

TY - CONF

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