Extensions to the OLAP framework for business analysis

Research output: Chapter in Book/Report/Conference proceedingConference contributionScientificpeer-review

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 change d 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.
Original languageEnglish
Title of host publicationProceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT)
EditorsJ. Cordeiro, A. Ranchordas
Place of PublicationBerlin
PublisherSpringer Verlag
Pages240-247
ISBN (Print)9789898111531
Publication statusPublished - 2008

Fingerprint

Processing
Industry
Sensitivity analysis
Managers
Agglomeration

Cite this

Caron, E. A. M., & Daniëls, H. A. M. (2008). Extensions to the OLAP framework for business analysis. In J. Cordeiro, & A. Ranchordas (Eds.), Proceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT) (pp. 240-247). Berlin: Springer Verlag.
Caron, E.A.M. ; Daniëls, H.A.M. / Extensions to the OLAP framework for business analysis. Proceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT). editor / J. Cordeiro ; A. Ranchordas. Berlin : Springer Verlag, 2008. pp. 240-247
@inproceedings{9974d200265a4d5785bc523f48f82e57,
title = "Extensions to the OLAP framework for business analysis",
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 change d 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.",
author = "E.A.M. Caron and H.A.M. Dani{\"e}ls",
year = "2008",
language = "English",
isbn = "9789898111531",
pages = "240--247",
editor = "J. Cordeiro and A. Ranchordas",
booktitle = "Proceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT)",
publisher = "Springer Verlag",
address = "Germany",

}

Caron, EAM & Daniëls, HAM 2008, Extensions to the OLAP framework for business analysis. in J Cordeiro & A Ranchordas (eds), Proceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT). Springer Verlag, Berlin, pp. 240-247.

Extensions to the OLAP framework for business analysis. / Caron, E.A.M.; Daniëls, H.A.M.

Proceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT). ed. / J. Cordeiro; A. Ranchordas. Berlin : Springer Verlag, 2008. p. 240-247.

Research output: Chapter in Book/Report/Conference proceedingConference contributionScientificpeer-review

TY - GEN

T1 - Extensions to the OLAP framework for business analysis

AU - Caron, E.A.M.

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

PY - 2008

Y1 - 2008

N2 - 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 change d 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.

AB - 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 change d 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.

M3 - Conference contribution

SN - 9789898111531

SP - 240

EP - 247

BT - Proceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT)

A2 - Cordeiro, J.

A2 - Ranchordas, A.

PB - Springer Verlag

CY - Berlin

ER -

Caron EAM, Daniëls HAM. Extensions to the OLAP framework for business analysis. In Cordeiro J, Ranchordas A, editors, Proceedings of the 3rd International Conference on Software and Data Technologies (ICSOFT). Berlin: Springer Verlag. 2008. p. 240-247