My dataset is an SSAS tabular cube.
In the cube - I have 2 "types" of data.
A: shared corporate data - materials, customers, dates, etc
B: sensitive data - required by a subset of folks by department (ie finance or operations or sales)
Therefore - I have access "rules"
A: Everyone can see this
B: only a subset of folks (based on AD group) can see this
What works great:
I set this up using the Models > Roles options in my tabular cube. When someone who doesn't have access to something in group B tries to see the data - they get (Blank) rather than the data.
What doesn't work great:
In the field list - all tables are listed - including the tables the user has no access to. Users are building their own reports, so I field "issue calls" daily that they "get nothing when they are building their report" which is actually by design... so I am in an endless loop of explaining what's happening & why. (So much fun!).
What I need:
Does anyone know if there is a way to display or hide objects from the fields listing based on a user's access to those objects? Like a dynamic hide option? My research has revealed nothing - but I remain optimitic that I just don't have the righ search criteria!
