Measure dimensions
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.
Creating a measure dimension
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:
- Right-click ...
Get IBM Cognos 10 Framework Manager now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.