Forum Discussion
Helper IIIDynamic parameter for filtering
I did not need a dynamic parameter. I just needed one RLS rule in the worker table. then a bi-directional relationship (with security filter applied to both directions as this is many to one relationship) to the Region table to filter the Region table by the RLS rule that gets applied to the worker table when a worker logs in. Region table filters the fact table so the logged in worker will only see what they are allowed to see.
If there are other dimension tables attached to the fact table then I will have to filter by a measure in the fact table to make sure the RLS rule gets carried through.
Helper IIII did not need a dynamic parameter. I just needed one RLS rule in the worker table. then a bi-directional relationship (with security filter applied to both directions as this is many to one relationship) to the Region table to filter the Region table by the RLS rule that gets applied to the worker table when a worker logs in. Region table filters the fact table so the logged in worker will only see what they are allowed to see.
If there are other dimension tables attached to the fact table then I will have to filter by a measure in the fact table to make sure the RLS rule gets carried through.