OLAP

OLAP (Online Analytical Processing) is an approach to analytical data processing that makes it possible to quickly examine information from different perspectives and combine dimensions. A user can, for example, track revenue by time, region, product or customer segment and switch between these views.

How OLAP works

Data is usually organized to support analytical queries and aggregations. The basis is the distinction between measured values, such as revenue or number of orders, and the dimensions that describe them. Typical operations include selecting part of the data (slice), combining dimensions (dice), expanding detail (drill-down) or changing perspective (pivot).

OLAP and reporting

OLAP is well suited for repeated multidimensional analyses and comparing results. It is not, however, a replacement for a good data model: correct definitions of indicators, data structure and query performance remain essential.

OLAP in an analytical environment

To make use of OLAP principles, it is important that users can change their view of the data safely and clearly.