March 2018
Beginner to intermediate
638 pages
16h 29m
English
Data model relationships must result in a single, unambiguous filter path across the tables of the model. In other words, a filter applied to one table must follow a single path to filter another table—the filter context cannot branch off into multiple intermediate tables prior to filtering a final table. In the following screenshot from the Relationships View, only one of the two relationships to the Auto Accidents fact table is allowed to be active (solid line):

When a filter is applied to the Auto Owners table, the inactive relationship between Insurance Polices and Auto Accidents provides a single, ...
Read now
Unlock full access