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.
Original post by Christopher Webb: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=866613&SiteID=1
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.