Forum Discussion
Row Level Security - MdxScript(Model) (45,60) Calculation error in measure
I understand that the easier approach is to create separate reports and publish them, but we are trying to reduce the maintenance of multiple reports.
Super UserRLS is restricting access to rows, not to visuals. All users will see all visuals, but for some users the UX will be bad as the visuals will have no data.
Hi Ibendlin,
Thankyou for your response. Yes, I an aware. My idea was to restrict data whenever a user does not have access( as specified in the access_control_view), they will be able to see the visual but not the data. This solution was fine for our requirement as we don't want to expose some of the financial metrics. For example, this is how it looks when a user doesn't have access.
The measure Access has been applied to filter for each visual.
I know this is not a direct way of doing things, but found this workaround and it is working for others who have implemented this but stopped working for me a little later.
- lbendlin
If your users represent sufficiently different audiences and access scopes then create separate reports.
We thought of implementing the same, but managing multiple reports would be a hassle.
Right now we only have 1 business user but in the coming year there would be a lot more. This would mean, if there's a change that needs to be done to a common visual, then we would have to do the same for multiple reports to keep the reports up to date. Hence, we're trying to look for an alternative solution.
Is there any other way, where I could restrict the data in visuals for different users based on their user_ids and access ( either true or false ) ?
Hi, Anonymous
If you've already resolved the current issue, you can mark your response as a "solution" so that other users know that the issue has been resolved and help others in the community. Thank you very much for your cooperation and participation!
Best Regards
Jianpeng Li