📊OLAP Cube
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
Common mistake
Key takeaways
- 1Added up in advance. Totals stored, not worked out live.
- 2A few dimensions. Product, region, month.
- 3Fast but fixed. New questions need a rebuild.