SSAS Don't want users in a role to be able to slice by one of the dimensions in the fact.
Page 1 of 1
SSAS Don't want users in a role to be able to slice by one of the dimensions in the fact.
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
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
Similar topics
» "Linking" two Fact tables for Cube users
» Role-playing dimensions
» Role playing Dimensions: When is it appropriate?
» Role-playing dimensions
» Role Playing dimensions
» Role-playing dimensions
» Role playing Dimensions: When is it appropriate?
» Role-playing dimensions
» Role Playing dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum