For this dataset, bridge tables are used to link three dimension tables (Sales Territory, Product, and Date) to the Sales and Margin Plan fact table. As shown in the following screenshot from the Relationships View, the bridge tables are hidden from the fields list in the Report View (gray shading) and bidirectional cross-filtering is enabled between the dimension and bridge tables:
Bridge tables hidden from the Report View
The bidirectional relationships enable filter selections on the three dimension tables (Sales Territory, Product, and Date) to impact the Sales and Margin Plan fact table as well as the Internet Sales and ...
