Forum Discussion
Solved
Varying RLS accross a report.
The below screenshot gives a very oversimplified example of the data relationship I am working with. I would like to apply Row Level Security for a report that the Managers will be looking at. In thi...
Try to create a second fact table, which contains the aggregated overall sales by manager. Don't create a relationship to your RLS table.
In that way the overall sales will not be filtered by RLS. But your first fact table, which contains low level data, will so.
Try to create a second fact table, which contains the aggregated overall sales by manager. Don't create a relationship to your RLS table.
In that way the overall sales will not be filtered by RLS. But your first fact table, which contains low level data, will so.