The analysis of actual or historical Sales and Margin Plan versus the Annual Sales Plan is one of the top requirements for this dataset. Given the granularity of the annual Sales and Margin Plan (Calendar Month, Product Subcategory, Sales Territory Region), it's necessary to create bridge tables reflecting the unique values of these columns.
The three bridge tables, which can be hidden from the user interface, enable relationships between the Date, Product, and Sales Territory dimension tables with the Sales and Margin Plan fact table.
In the following example, the Sales Territory dimension table query is referenced as a source and the unique values of the Sales Territory Region column are retrieved via the Table.Distinct() ...
