Explains what the feature is or what its benefits are to the user or customer.
You can quickly create a relationship (or link) between tables that allows you to combine them in a single search. Choose a column to join on that both tables contain (e.g. employee ID or product key).
- Cannot be scripted.
- Can be created, viewed, and edited through the Web interface.
- Can be used to link tables, imported data, and worksheets, not just tables loaded through TQL.
When creating a link between the columns in two data sources, the columns being linked must have the same data type, with the same meaning. That is, they must represent the same data. Normally, you'll make this kind of link from a fact table column to a column in a dimension table that uniquely identifies a logical entity in your data such as Employee ID for a person, Product ID for a product, or Date Key for a specific date in a date lookup table.
To create a relationship through the Web interface:
- Click on the Data icon, on the left navigation bar.
- Click on the name of the data source you want to link from.
- Select Relationships.
- If there are already some existing relationships, scroll down and click Add Relationship. Otherwise, continue to the next step.
- Click on Source Column and select the column you want to link in the source table.
- Under Destination Table find and select the table that you want to link to.
- Click on Destination Column and select the column you want to link to in the destination table.
- Click Add Key to add the link.
- Name your relationship and optionally give it a description.
- Click Add Relationship.
- Repeat these steps for creating a link until all the links you want to make for your table have been created.