Skip to content
BENIBIX Learn

OLAP Cube

Data📊 Analytics & BISemantic Layer

Also known as Data Cube, Multidimensional Cube, MOLAP

Totals worked out ahead of time, for each mix of a few fields.

Think of it like

It is like a Rubik's cube made of numbers. Each small block holds the sales for one thing, place and month.

Example

A manager clicks from total sales to one region, then to one product. Each click is instant. The cube has every total ready.

Why it matters

It explains why older BI felt fast but rigid. Many modern tools still borrow the idea as a cache.

Definition

An OLAP cube stores numbers worked out in advance for every mix of a few dimensions. A sales cube might have product, region and month as its sides. Each cell holds the total for one product, in one region, in one month. Questions are fast because the answers are already added up. Cubes were the main way to get fast answers before modern column-based warehouses.
Each block is one product, one region and one month. Its total is ready before anyone asks.

Common mistake

Adding too many dimensions. The number of cells explodes, and the cube takes hours to rebuild.

Key takeaways

  1. 1
    Added up in advance. Totals stored, not worked out live.
  2. 2
    A few dimensions. Product, region, month.
  3. 3
    Fast but fixed. New questions need a rebuild.

Compare