Using a consumption model in Bussiness Builder does not solve the problem because when creating a model all users who are assigned to that space will have access to the sensitive content, if the sensitive content is removed the key users will not have access either.
Using DACs also doesn't solve the problem, as I don't want to restrict access to a specific dimension, but to an entire column (measure).
To try to better exemplify the scenario, I am developing a model for a human resources (HR) team, user "X" must have access to the measure "salary" of all employees in the company, but user "Y" must have access to all other model information minus the "salary" measure. Even if I create a separate view for each user, they are in the same space, it wouldn't stop user "Y" from creating a new story and viewing data from user X's view.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.