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.
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.
Super UserIf 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 ) ?
- lbendlin
Your job as a report designer is to make it easier for the users to get to actionable insights. Instead, you waste time trying to make a harder.
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.