May 2013
Intermediate to advanced
186 pages
3h 45m
English
A measure dimension is a collection of facts. A measure dimension is created from one or more query subjects that have a valid relationship between them.
Measure dimensions should only be composed of quantitative items and they do not contain any keys with which join them together. Therefore, to join a measure dimension to a regular dimension, it is necessary to create the joins in the underlying query subjects.
We will create a measure dimension using the great_outdoors_warehouse from the IBM Cognos Samples. From the model, we will use the Inventory Fact query from the Business View as a relational data source to build our measure dimension.
We will create a measure dimension as follows: