# OLAP Cube

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

**Field:** Data Engineering  
**Category:** Analytics & BI  
**Also known as:** Data Cube, Multidimensional Cube, MOLAP

## 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.

## 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.

## 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.

## Common mistake

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

## Three principles

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

## Related terms

- [Online Analytical Processing (OLAP)](https://learn.benibix.com/term/data/olap)
- [Measure (Analytics)](https://learn.benibix.com/term/data/measure)
- [Semantic Layer](https://learn.benibix.com/term/data/semantic-layer)
- [Columnar Storage](https://learn.benibix.com/term/data/columnar-storage)
- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)

## Told apart from

- [OLAP vs OLAP Cube](https://learn.benibix.com/compare/olap-vs-olap-cube): People think OLAP means a cube. OLAP is the kind of work: big reads that add up many rows to answer questions. A cube is one old way to do that work, by adding up every total in advance. Most OLAP today runs in column-based warehouses with no cube at all.

![A cube split into small blocks. Its three sides are labelled product, region and month. One block is highlighted and labelled: shoes, Europe, March, sales 4,200. A note says every block is added up in advance.](https://learn.benibix.com/diagrams/olap-cube.svg)

---

Source: https://learn.benibix.com/term/data/olap-cube
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
