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 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...