It explains:
What blends are and how they represent entity relationships (one-to-one or one-to-many).
How to create, name, and configure blends between related tables.
How to handle blank values, add multi-field links, and set relationship types.
How filtering works across relationships (one filters many).
Best practices for maintaining data integrity and optimizing relational reporting.
Key Steps
Step 1: Understanding Blends 0:00
-
Blends are used to tie entities together in your database.
-
Each blend has an icon indicating the type of relationship (one-to-many or one-to-one).
Step 2: Accessing Existing Blends 0:11
-
Review the existing list of blends to understand current relationships.
Step 3: Editing a Blend 0:24
-
Select a blend to edit and familiarize yourself with the relationship setup.
Step 4: Naming the Blend 0:34
-
Choose a name for the blend that reflects the two tables being related for easy identification.
Step 5: Selecting Tables to Relate 0:47
-
Identify the tables you are relating (e.g., Campaigns table to Responses table).
Step 6: Handling Blank Values 0:58
-
If either table has blank values in the joining columns, tick the box to include these in the relationship.
Step 7: Defining the Relationship 1:10
-
Specify the columns that define the relationship (e.g., Campaign ID from both tables).
Step 8: Adding Multi-Field Links 1:28
-
If necessary, click the plus button to add additional fields to the blend relationship.
Step 9: Setting Relationship Type 1:41
-
Leave the relationship type on 'matching values' unless specific ETL routines require outer joins.
Step 10: Configuring Filters 2:16
-
Understand the default filter setting (automatic) which applies filters across both tables.
Step 11: Applying One Filters Many 3:12
-
Recognize that the one side of the relationship filters the many side (e.g., Campaign ID filters Responses).
Step 12: Understanding Filter Effects 4:07
-
Be aware that filters applied to the many side do not affect the one side of the relationship.
Cautionary Notes
-
Ensure that the correct tables and columns are selected to avoid data integrity issues.
-
Be cautious when handling blank values as they can affect the relationship outcomes.
Tips for Efficiency
-
Use clear and descriptive names for blends to facilitate easier identification.
-
Regularly review existing blends to ensure they meet current reporting needs.