Relationships are connections between tables in a semantic model that define how data is related and can be joined together. They are crucial for building accurate and meaningful reports and insights from your data. By creating relationships between tables, you can establish hierarchies, perform aggregations, and enable time intelligence functions.
Step 1: Navigate to Your Workspace
Step 2: Select Your Semantic Model
In the workspace, click on your semantic model.
Step 3: Open the Data Model
After selecting your semantic model, open the data model.
Step 4: Mark as Date Table (If Not Done Already)
This step is crucial if you are dealing with time intelligence functions. Mark the appropriate table as a date table.
Step 5: Create a New Relationship
In the semantic model, select the column from your fact table and drag it to the corresponding column in the dimension table to create a relationship. Ensure the relationship is accurate by reviewing the relationship settings and then save the changes.
Step 6: Verify the Relationship
Finally, verify the relationship by running a few queries or generating test reports to ensure the data joins correctly.
Good work and have a great day!
Snorre Glemmestad 