Forum Discussion
Object Level Security that is measure dependent
In a tabular model for analysis services, the lowest level of a shared product dimension needs to be hidden from a a group of users if they select inventory measures, but they can see all product col...
lbendlin
Super User
Super Useruse two copies of the Product Dimension table. Join the one with the visible materials column to the invoices and the one with then hidden materials column to the inventory
If inventory is joined to the version of the Product dimension with the material column hidden, wouldn't that hide material from all users? Most users should see inventory by material. It's only sales reps that need to have material hidden.