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

Determinants


Determinants are one of the most confusing aspects of Framework Manager and are therefore the least understood. As a result, many modelers will never use or create them. However, determinants can play an important role in the performance of your Framework Manager model.

Determinants allow a table with one level of detail (or granularity) to behave as if it has a completely different level of detail. Generally determinants will be used with dimension tables, where fact tables join the dimension table at more than one level in the dimension.

A common example of where determinants would be used is with a date dimension table, with a granularity at the day level. If all the fact tables are joined to this table at the day level, there would be no need for determinants.

A join between a monthly forecast table aggregated at the month level with one row per month, and with this date dimension table would return between 28 and 31 records, depending upon the month. This could cause problems...

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