Reader small image

You're reading from  IBM Cognos 10 Framework Manager

Product typeBook
Published inMay 2013
PublisherPackt
ISBN-139781849685764
Edition1st Edition
Right arrow
Author (1)
Terence Phillip Curran
Terence Phillip Curran
author image
Terence Phillip Curran

Terry Curran gained an interest in computers while studying for his first degree in Biological Chemistry at the University of Kent. He went on to work as a computer operator for a national supermarket company. After working for several years as a computer operator, he went to Brighton Polytechnic, leaving with a Higher National Diploma in Computer Studies. Upon completion of his studies, he worked as a computer advisor at the City of London Polytechnic, assisting staff and students with their computer problems, and providing support for the various database systems in use across the Polytechnic. After taking voluntary redundancy from this post, he proceeded to the University of Stirling where he gained an MSc in Software Engineering. After graduating from the University of Stirling, Terry commenced working for a software consultancy company. While working for this company, Terry assisted with the writing of a software package for the publishing industry using Cognos PowerHouse. While working for this company, Terry gained experience in Business Intelligence Reporting tools, being asked to familiarize himself with Cognos Impromptu and PowerPlay in order to promote the use of these tools to clients. After this company ceased trading, Terry embarked on a career as a freelance computer consultant and contractor, using his experience with Cognos PowerHouse, various computer systems and databases, and Cognos Impromptu and PowerPlay, and later Cognos 8 and Cognos 10. Terry continues to work as a freelance Cognos Business Intelligence consultant and contractor, making use of his extensive knowledge and experience of IBM Cognos Business Intelligence Reporting. During the past 15 years, Terry has worked for a range of different industries including aviation, pharmaceuticals, insurance, logistics, and manufacturing to name a few. Terry is currently working for Ultra Electronics Command and Control Systems as a freelance Cognos consultant. Terry Curran was a technical reviewer for the book IBM Cognos 8 Report Studio Cookbook, Packt Publishing.
Read more about Terence Phillip Curran

Right arrow

Regular dimensions


A regular dimension contains one or more user-defined hierarchies, with each hierarchy consisting of the following components:

  • Levels: These are used to roll-up measures

  • Keys: Each item in a level must have a unique key defined

  • Captions: These are used as labels for the levels

  • Attributes: These contain additional information regarding the levels

Every regular dimension requires that each level has a key and a caption specified, and that the caption be a string data type.

Regular dimensions are based on data source or model query subjects that have already been defined in your model.

Creating a regular dimension

We will create a time dimension using the great_outdoors_warehouse from the IBM Cognos Samples. From the model, we will use the Time query from the Business view item as a relational data source to build our regular dimension.

Create your regular dimension as follows:

  1. Right-click on your namespace, and navigate to Create | Regular Dimension, or alternatively click on...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
IBM Cognos 10 Framework Manager
Published in: May 2013Publisher: PacktISBN-13: 9781849685764

Author (1)

author image
Terence Phillip Curran

Terry Curran gained an interest in computers while studying for his first degree in Biological Chemistry at the University of Kent. He went on to work as a computer operator for a national supermarket company. After working for several years as a computer operator, he went to Brighton Polytechnic, leaving with a Higher National Diploma in Computer Studies. Upon completion of his studies, he worked as a computer advisor at the City of London Polytechnic, assisting staff and students with their computer problems, and providing support for the various database systems in use across the Polytechnic. After taking voluntary redundancy from this post, he proceeded to the University of Stirling where he gained an MSc in Software Engineering. After graduating from the University of Stirling, Terry commenced working for a software consultancy company. While working for this company, Terry assisted with the writing of a software package for the publishing industry using Cognos PowerHouse. While working for this company, Terry gained experience in Business Intelligence Reporting tools, being asked to familiarize himself with Cognos Impromptu and PowerPlay in order to promote the use of these tools to clients. After this company ceased trading, Terry embarked on a career as a freelance computer consultant and contractor, using his experience with Cognos PowerHouse, various computer systems and databases, and Cognos Impromptu and PowerPlay, and later Cognos 8 and Cognos 10. Terry continues to work as a freelance Cognos Business Intelligence consultant and contractor, making use of his extensive knowledge and experience of IBM Cognos Business Intelligence Reporting. During the past 15 years, Terry has worked for a range of different industries including aviation, pharmaceuticals, insurance, logistics, and manufacturing to name a few. Terry is currently working for Ultra Electronics Command and Control Systems as a freelance Cognos consultant. Terry Curran was a technical reviewer for the book IBM Cognos 8 Report Studio Cookbook, Packt Publishing.
Read more about Terence Phillip Curran