Skip to Main Content
IBM Cognos 10 Framework Manager
book

IBM Cognos 10 Framework Manager

by Terence Phillip Curran
May 2013
Intermediate to advanced content levelIntermediate to advanced
186 pages
3h 45m
English
Packt Publishing
Content preview from IBM Cognos 10 Framework Manager

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:

  1. Right-click ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

IBM Cognos 10 Report Studio: Practical Examples

IBM Cognos 10 Report Studio: Practical Examples

Filip Draskovic, Roger Johnson
IBM Cognos Dynamic Query

IBM Cognos Dynamic Query

Nigel Campbell, Henk Cazemier, Robert Hatfield, Martin Petitclerc, Glen Seeds, Jason Tavoularis

Publisher Resources

ISBN: 9781849685764Supplemental Content