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

Special purpose joins


There are some special purpose joins which cannot be automatically generated during the import of the data source from your relational database. These special purpose joins can only by created by the modeler.

Role playing dimensions

A table that has multiple relationships between itself and another table is known as a role playing dimension. A good example is an Orders Fact, which may have multiple relationships to the Customer Dimension on keys such as Sold To, Ship To, and Bill To:

This situation can create problems with joins in Framework Manager since there are now multiple joins paths between two tables. If you run the Model Advisor (see Chapter 2, Proven Practice), this is one of the of the errors which will be diagnosed and must be fixed in the model.

The solution in Framework Manager is to create a model query subject for each role. The model query subjects query items that can then be renamed to have an appropriate name for their use. A single relationship can...

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}