Hiding an Entire Dimension Using Role Based Security

It was a nice three weeks in Peru but I’m glad to be back in the land of warm showers, toilets with seats, and cold drinks. I’ll miss the $4 filet mignon’s though.
Anyway, while I was gone I had a request come in about setting up security for a single user (we’re a very liberal company; we give all our employees access to all data!). The user needed access to a cube, but only have access to five of ten dimensions within it. Easy enough I thought. Finally a chance for me to screw around with security.
Got to working on it. Role based security – simple. Went to the Dimensions option in Edit Role, looked at the drop down for Access…yet didn’t see ‘None’. HUH? Only Read and Read/Write. Messed around and couldn’t find an acceptable solution so I posted something to the newsgroup.
Deepak responded, informed me I wasn’t the only person with this question, and pointed to a thread on MSDN.

Christopher filed an issue with Connect, however it was closed with a status of ‘Won’t Fix’. Ugh. If you can do it on the cube level, how hard would it be to do the same on the dimensional level?
My solution was to create a new cube with linked measure groups and dimensions. Yea, it’s probably about the worst solution possible, but the user needed access within 24 hours.
Totally frustrating.
This entry was posted in Uncategorized. Bookmark the permalink.

One Response to Hiding an Entire Dimension Using Role Based Security

  1. Cem says:

    Have you tried to create perspectives?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s