Forum Discussion
row level security & overall sum
Anonymous I think easiest and the only solution is to bring in only sum of budget amount as a second data source in the report. There won't be any RLS applied to that second data source and so it will work in both desktop and service regardless of the RLS defined on your original dataset.
ankitpatira : thanks for your respons. I was also thinking about that solution.
I hoped there was another wa, because in reality I don't want to display only the budgets but also some calculated values.
As I understand you well, I'v to copy all the tables I need, define all the calculated columnes again and define all the measures again (but with references to the new tables).
A lot of work I hope I don't have to do!
Hi Anonymous,
As we know, the RLS rule is applied on the table level with the report. You can image if one part of table data are affected by RLS rule but others will not, it's hard to decide which part of the table should be affected. So both detail information and total value are affected by RLS rule make sense.
In your scenario, the only way to work around this issue is suggested by ankitpatira, to create another table which doesn't apply RLS rule, and use this table to calculate total values.
Best Regards,
Qiuyun Yu