Archive for June, 2008

DB2 Cube Models

Posted in Data Warehousing, Model Driven Development with tags on June 12, 2008 by Patricio

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