May 2013
Intermediate to advanced
186 pages
3h 45m
English
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.
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 ...
Read now
Unlock full access