Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
IBM Cognos 10 Framework Manager

You're reading from  IBM Cognos 10 Framework Manager

Product type Book
Published in May 2013
Publisher Packt
ISBN-13 9781849685764
Pages 186 pages
Edition 1st Edition
Languages
Author (1):
Terence Phillip Curran Terence Phillip Curran
Profile icon Terence Phillip Curran

Table of Contents (19) Chapters

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 chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime}