Single direction relationships

  1. Access a simple star schema data model with row count measures for each table.
One-to-many single direction relationship model
  • The relationships are all single-direction from the dimension to the fact table.
  1. Add the row count measures to the report canvas and create slicer visuals from the dimension tables.
Relationship and cross filter testing visualization
  • With single-direction relationships, a selection on any of the slicers will only impact its own table and the sales table.