Traditional web-based reporting with SAS BI tools

Hiding dimensions from users in a cube

Reply
Regular Contributor
Posts: 163

Hiding dimensions from users in a cube

Hi:
I created a calculated member that is based on a measure restricted on certain dimensions. I want the users to see this calculated measure but not the dimension ( anything in it is irrelavant to the user except when used as restriction to the measure). Is there a way to hide dimensions from users?

Thanks,
jp
SAS Employee
Posts: 37

Re: Hiding dimensions from users in a cube

You can hide a dimension from a user or group of users by denying ReadMetadata permisisons for that dimension. However, if a calculated member or measure is based on this dimension, the user will have to have access to the underlying dimension to consume the calculated member/measure.
Regular Contributor
Posts: 163

Re: Hiding dimensions from users in a cube

Thanks TSBruce!

jp
Ask a Question
Discussion stats
  • 2 replies
  • 245 views
  • 0 likes
  • 2 in conversation