Security filtering

Did you notice that Distinct City Count did not change in the last exercise? The RLS you created used fields from the Dim_Employee table and automatically filters data within the fact table, but Distinct City Count counts values in the dimensional table Dim_City.

RLS does not access this data unless we apply security filtering in both directions. Your job is to update this so the correct value is displayed.

If you lost progress open workbook 2_3_security_filtering.