Andyblg's Blog

October 1, 2009

OLAP models and OLAP cubes

Filed under: OLAP — andyblg @ 02:22

IBM review concepts “OLAP models” and “OLAP cubes” (to ibm’s page)

…”OLAP models and OLAP cubes are two critical concepts in DB2 DWE OLAP services. A cube model is built to represent a data structure and relationship in an OLAP data mart. A cube model contains metadata objects that describe relationships within the data that resides in the base tables and also describes where pertinent data is located. A cube model provides a new perspective for the information consumers from which to understand their data”…

…”An OLAP cube has a specific set of similar but more restrictive metadata objects derived from the parent cube model, including cube dimensions, cube hierarchies, cube levels, and a cube facts object. A cube can have only one cube hierarchy defined for each cube dimension, but a dimension can have many hierarchies that are defined for the cube model“…

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at

%d bloggers like this: