Joining Tables in a Data Model

The reporting views contain primary and foreign keys which can be used to join views. By joining views, you can combine columns from multiple views to include in a single data model. Primary keys are unique internal identifiers for a single view. Foreign keys are internal identifiers that match the primary key of another view, providing a cross-reference between the two views. To join two views, you must link the foreign key in a view to the primary key in its host view.

To join tables in a data model:

1. Click Catalog.
2. In the Folders navigation tree, expand Shared Folders and select your EnterpriseTrack reports folder (for example, ET_Reports).
3. Select a data model and click Edit.
4. In the SQL tab, join the relevant tables on a common column.
5. In the Schema pane, select and drag a column from one schema to the corresponding column of the schema on which you want the join operation to occur.
6. Apply any conditions to the join.
7. In the Results tab, verify your SQL query.
8. Click Save.

Related Topics

Getting Started with EnterpriseTrack Reports in BI Publisher

Generating Reports

Setting Up an Email Server for Report Delivery

Scheduling Reports