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:
- Click Catalog.
- In the Folders navigation tree, expand Shared Folders and select your EnterpriseTrack reports folder (for example,
ET_Reports). - Select a data model and click Edit.
- In the SQL tab, join the relevant tables on a common column.
- 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.
- Apply any conditions to the join.
- In the Results tab, verify your SQL query.
- Click Save.