Built-in indicators to automatically detect interesting cells in a cube

  • Authors:
  • Véronique Cariou;Jérôme Cubillé;Christian Derquenne;Sabine Goutier;Françoise Guisnel;Henri Klajnmic

  • Affiliations:
  • ENITIAA, Nantes CEDEX 3, France;EDF Research and Development, Clamart, France;EDF Research and Development, Clamart, France;EDF Research and Development, Clamart, France;EDF Research and Development, Clamart, France;EDF Research and Development, Clamart, France

  • Venue:
  • DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

Abstract

In large companies, On-Line Analytical Processing (OLAP) technologies are widely used by business analysts as a decision support tool. Nevertheless, while exploring the cube, analysts are rapidly confronted by analyzing a huge number of visible cells to identify the most interesting ones. Coupling OLAP technologies and mining methods may help them by the automation of this tedious task. In the scope of discovery-driven exploration, this paper presents two methods to detect and highlight interesting cells within a cube slice. The cell's degree of interest is based on the calculation of either test-value or Chi-Square contribution. Indicators are computed instantaneously according to the user-defined dimensions drill-down. Their display is done by a colorcoding system. A proof of concept implementation on the ORACLE 10g system is described at the end of the paper.