Skip to Main content Skip to Navigation
Conference papers

A Report-Driven Approach to Design Multidimensional Models

Abstract : Today, large organisations and regulated markets are subject to the control of external audit associations, which require the submission of a huge amount of information in the form of predefined and rigidly structured reports. The compilation of these reports requires the extraction, transformation and integration of data from different heterogeneous operational databases. This task is usually performed by developing a software ad hoc for each report, or by adopting a data warehouse and analysis tools, which are now established technologies. Unfortunately, the data warehousing process is notoriously long and error prone, and is therefore particularly inefficient when the output of the data warehousing is represented by a limited number of reports. This article presents “MMBR”, an approach that can generate a multidimensional model from the structure of expected reports as data warehouse output. The approach is able to generate the multidimensional model and populate the data warehouse by defining a knowledge base specific to the domain. Although the use of semantic information in data storage is not new, the novel contribution of our approach is represented by the idea of simplifying the design phase of the data warehouse, making it more efficient, by using an industry-specific knowledge base and a report-based approach.
Document type :
Conference papers
Complete list of metadata

Cited literature [24 references]  Display  Hide  Download
Contributor : Hal Ifip Connect in order to contact the contributor
Submitted on : Thursday, March 7, 2019 - 3:28:06 PM
Last modification on : Friday, June 11, 2021 - 9:26:03 AM
Long-term archiving on: : Sunday, June 9, 2019 - 9:48:54 AM


Files produced by the author(s)


Distributed under a Creative Commons Attribution 4.0 International License



Antonia Azzini, Stefania Marrara, Andrea Maurino, Amir Topalović. A Report-Driven Approach to Design Multidimensional Models. 7th International Symposium on Data-Driven Process Discovery and Analysis (SIMPDA), Dec 2017, Neuchatel, Switzerland. pp.105-127, ⟨10.1007/978-3-030-11638-5_6⟩. ⟨hal-02060695⟩



Record views


Files downloads