SSAS Don't want users in a role to be able to slice by one of the dimensions in the fact.

View previous topic View next topic Go down

SSAS Don't want users in a role to be able to slice by one of the dimensions in the fact.

Post  ebry74 on Fri Jun 05, 2015 3:15 pm

We have a fact table with a measure of Paid Dollars, containing dimension keys for Employee, Organization, Date, and so on. We want all users to be able to see paid dollars, but only certain users should be able to slice the Paid Dollars by Employee as this exposes salary information. Is there a way to expose the single measure group and not expose the Employee Dimension to a specific role in the cube?

My only other thought is to create a second identical measure group that doesn't contain the employee key, but this would require duplicating every calculated measure and renaming all the measures in that group. I feel there has to be a way to leverage the existing measure group while limiting who can slice by Employee.

Any and all thoughts are very appreciated.

Thanks, Bryan

ebry74

Posts : 5
Join date : 2011-06-20

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum