DB2 Cube Models

DB2 cube models are an interesting representation of OLAP Cubes and metadata objects:  A cube model contains:

·         Cube facts objects

·         Cube dimensions

·         Cube hierarchies

·         Cube levels

Cube Model:

Dimension Detail:

The Cube:

The model is very close to the OLAP implementation, as expected… but the way they model cube dimension hierarchies is very interesting and helps the business analyst to focus on the business needs.

  You can find more from: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.db2_olap.doc/cmdcubemodel.htm