March 2018
Beginner to intermediate
638 pages
16h 29m
English
In this dataset, the Sales Territory, Product, Date, Currency, and Promotion dimension tables are related to both the Internet Sales and Reseller Sales fact tables. As shown in the following screenshot from the Relationships View, these relationships and the three dimension tables specific to either fact table all have single-direction cross-filtering enabled:

Unlike the shared dimensions, the Reseller and Employee dimension tables are exclusively related to the Reseller Sales fact table and the Customer dimension is exclusively related to the Internet Sales fact table. This is a common scenario for ...
Read now
Unlock full access