HOLAP, MOLAP and ROLAP

DWH Concepts and Fundamentals

Online Analytical Processing (OLAP)

Multidimensional OLAP (MOLAP) - multi-dimensional graph having various axes.

Each axis represents a category of business called a dimension (eg location, product, time, employee etc). The data points are the business transactional values called measures.

Relational OLAP (ROLAP) –  FACT -Dimension Tables

MOLAP, ROLAP, And HOLAP