OLAP Data Cube

A vision to see different beautiful views

Cube is a shortcut for multidimensional dataset, given that data can have an arbitrary number of dimensions. The term hypercube is sometimes used, especially for data with more than three dimensions.

Each cell of the cube holds a number that represents some measure of the business, such as sales, profits, expenses, budget and forecast.

OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system. Measures are derived from the records in the fact table and dimensions are derived from the dimension tables.

Operations:

Slice(切片):

Dice(切块):

Drill Down/Roll Up(钻取/上卷):

Pivot(旋转/翻面):

---------------------------------------------------------------------------------------------------------------------------------------