An integrated decision-making prototype based on OLAP systems and multicriteria analysis for complex decision-making problems

Omar Boutkhoum,Mohamed Hanine

doi:10.1186/s40535-017-0041-6

Omar Boutkhoum, Mohamed Hanine

Open Access

https://doi.org/10.1186/s40535-017-0041-6

Copy DOI

Journal: Applied Informatics	Publication Date: Oct 30, 2017
Citations: 6	License type: open-access

Affiliation: Cadi Ayyad University

Abstract

OLAP (Online Analytical Processing) system appears as a revolutionary technology that provides adequate analytic solutions for decision support. Using OLAP, analysts and policymakers are able to process and analyze data in an interactive, fast, and effective way according to several axes. This provides a clear vision of their business at any time and in real time. However, these systems suffer from certain limitations related to the consideration of both the multicriteria and fuzzy aspects of multidimensional data when making decisions. To overcome these limitations, we propose an integrated decision-making prototype based on OLAP system and multicriteria analysis (MCA) to generate a hybrid analysis process dealing with complex multicriteria decision-making situations. This proposed solution, based on our previous contributions, allows the analyst to extract data from OLAP data cube model and analyze them using OLAP operators and MCA methods.

Highlights

In a decision-making context, analysis is an intellectual process that allows generating knowledge from hypotheses and data (Codd et al 1993)
To make that analysis applicable, OLAP system as a business intelligence (BI) technology, appears among the most adequate multidimensional analysis tools most used by decision makers and analysts who need to transform data into actionable information, which has the effect of facilitating the management of the performance of organizations and having a clear vision of their activities at all times and in real time
We propose a software implementation based on OLAP systems and multicriteria analysis to concretely test the intake of the proposed solutions

Summary

Introduction

In a decision-making context, analysis is an intellectual process that allows generating knowledge from hypotheses and data (Codd et al 1993). This can be formalized by explaining a phenomenon and proposing solutions or recommendations for decision making. Boutkhoum and Hanine Appl Inform (2017) 4:11 and necessary services for efficient, rational, and analytic processing of data. The functionalities of these systems, based on a multidimensional database approach (Kimball 1996), are characterized by the ability to support efficient and flexible exploration of multidimensional cubes in data warehouses (Aligon et al 2015)

Objectives

Methods

Conclusion