Forum Discussion
Getting summary data/calculations past row-level security
We have a business with multiple locations. I have set up RLS to each manager's reports to show only their locations' details. (Sales totals, etc.) Each row transaction has a location column, so the RLS just limits the calculations to those rows that match their location.
Is there a general strategy to allow some summary calculations about other locations through and be seen by each location? Examples would be sales percentages by category, overall margins, A/R collection percentages, etc.... nothing that shows individual amounts or totals, but just averages. (This would give them some helpful context to their own location's report.)
The RLS excludes all of the other locations' data, so measures calculating summaries aren't showing results for anything other than each manager's location. Is there a way to sidestep RLS for specific measures or pass that information through?
Thank you in advance for any help. Mainly just looking to be pointed in the right direction, if possible.
1 Reply
- Greg_DecklerCommunity Champion
J_Melton_TX The general strategy is to create a disconnected summary table of the information that is not subject to RLS.