Explanation of exceptional values in multidimensional databases

Research output: Contribution to journalArticleScientificpeer-review

Abstract

In this paper, we describe an extension of the OnLine Analytical Processing (OLAP) framework with causal explanation, offering the possibility to automatically generate explanations for exceptional cell values. This functionality can be built into conventional OLAP databases using a generic explanation formalism, which supports the work of managers in diagnostic processes. The central goal is the identification of specific knowledge structures and reasoning methods required to construct computerized explanations from multi-dimensional data and business models. The methodology was tested on a case study involving the comparison of financial figures of a firm’s business units. The findings suggest improved decision-making by managers because the current tedious and error-prone manual analysis process is enhanced by automated problem identification and explanation generation. It is also noted that this novel methodology has general utility for decision-support systems, for example, for automated diagnosis in the financial and accountancy domain.
Original languageEnglish
Pages (from-to)884-897
JournalEuropean Journal of Operational Research
Volume188
Issue number3
DOIs
Publication statusPublished - 2008

Fingerprint

Online Analytical Processing
Managers
Multidimensional Model
Multidimensional Data
Methodology
Business Model
Identification Problem
Decision Support Systems
Processing
Decision support systems
Data Model
Industry
Figure
Diagnostics
Reasoning
Decision making
Decision Making
Unit
Cell
Business

Cite this

@article{4d8d99d782de416fb0a39e77ae8aadcb,
title = "Explanation of exceptional values in multidimensional databases",
abstract = "In this paper, we describe an extension of the OnLine Analytical Processing (OLAP) framework with causal explanation, offering the possibility to automatically generate explanations for exceptional cell values. This functionality can be built into conventional OLAP databases using a generic explanation formalism, which supports the work of managers in diagnostic processes. The central goal is the identification of specific knowledge structures and reasoning methods required to construct computerized explanations from multi-dimensional data and business models. The methodology was tested on a case study involving the comparison of financial figures of a firm’s business units. The findings suggest improved decision-making by managers because the current tedious and error-prone manual analysis process is enhanced by automated problem identification and explanation generation. It is also noted that this novel methodology has general utility for decision-support systems, for example, for automated diagnosis in the financial and accountancy domain.",
author = "E.A.M. Caron and H.A.M. Dani{\"e}ls",
year = "2008",
doi = "10.1016/j.ejor.2007.04.039",
language = "English",
volume = "188",
pages = "884--897",
journal = "European Journal of Operational Research",
issn = "0377-2217",
publisher = "Elsevier Science BV",
number = "3",

}

Explanation of exceptional values in multidimensional databases. / Caron, E.A.M.; Daniëls, H.A.M.

In: European Journal of Operational Research, Vol. 188, No. 3, 2008, p. 884-897.

Research output: Contribution to journalArticleScientificpeer-review

TY - JOUR

T1 - Explanation of exceptional values in multidimensional databases

AU - Caron, E.A.M.

AU - Daniëls, H.A.M.

PY - 2008

Y1 - 2008

N2 - In this paper, we describe an extension of the OnLine Analytical Processing (OLAP) framework with causal explanation, offering the possibility to automatically generate explanations for exceptional cell values. This functionality can be built into conventional OLAP databases using a generic explanation formalism, which supports the work of managers in diagnostic processes. The central goal is the identification of specific knowledge structures and reasoning methods required to construct computerized explanations from multi-dimensional data and business models. The methodology was tested on a case study involving the comparison of financial figures of a firm’s business units. The findings suggest improved decision-making by managers because the current tedious and error-prone manual analysis process is enhanced by automated problem identification and explanation generation. It is also noted that this novel methodology has general utility for decision-support systems, for example, for automated diagnosis in the financial and accountancy domain.

AB - In this paper, we describe an extension of the OnLine Analytical Processing (OLAP) framework with causal explanation, offering the possibility to automatically generate explanations for exceptional cell values. This functionality can be built into conventional OLAP databases using a generic explanation formalism, which supports the work of managers in diagnostic processes. The central goal is the identification of specific knowledge structures and reasoning methods required to construct computerized explanations from multi-dimensional data and business models. The methodology was tested on a case study involving the comparison of financial figures of a firm’s business units. The findings suggest improved decision-making by managers because the current tedious and error-prone manual analysis process is enhanced by automated problem identification and explanation generation. It is also noted that this novel methodology has general utility for decision-support systems, for example, for automated diagnosis in the financial and accountancy domain.

U2 - 10.1016/j.ejor.2007.04.039

DO - 10.1016/j.ejor.2007.04.039

M3 - Article

VL - 188

SP - 884

EP - 897

JO - European Journal of Operational Research

JF - European Journal of Operational Research

SN - 0377-2217

IS - 3

ER -