Home  >  Oracle Data Warehouse & Business Intelligence > Data Warehouse cubes, dimensions

What is a CUBE in data warehousing concept ?

Cubes are logical representation of multidimensional data. The name of "cube" is visually related to a 3 dimensional model, but we can have more than 3 dimensions.

Here is a 3 dimensional cube:

You can see that a cube has some dimensions. In this case we have 3 dimensions: product, location, time. In real life we can have more than 3 dimensions. In that case, inside a cube we can have another cubes.

A 3 dimensional cube is made of cubes. Each cube can be imagines as a sum of cubes.

More information about  this subject ( Data Warehouse cubes, dimensions ) you can get from  www.in-oracle.com