Hi!
Is it so Difficult to set up this kind of security? (Or is it to simple?) I
have had this query in this newsgroup for one week and no answers?

How do I set up security to just completly hide a dimension.
I would like the same behaviour as if I use a perspektive and just invisible
a dimension.
Example:
In my cube I have a measure group + dimTime + dimCustomer + dimProduct
One group of my users shouldn't see the customer dimension at all.
I've tried but can't get through with this!
Anyone who knows?

Best, Jocke

Hi Jocke,

This post in the Analysis Services MSDN Forum addresses your scenario -
not sure whether the work-around meets your needs:


http://forums.microsoft.com/MSDN/Sho...72312&SiteID=1
access to a whole dimension

Christopher Webb
MVP

In AS2K dimension security I could deny access to a whole dimension
using the 'Fully Restricted' setting on a role. In AS2005 I can't see
how to do the same thing - the only thing I can do is to deny access to
every member on every attribute but even then I still see the dimension
name in the metadata. BOL suggests it is possible but its descriptions
of the UI must have been written before RTM and don't bear much
resemblence to the current situation; I've also had a go at setting some
of the properties on the permissions object in the XMLA definition of my
cube but they don't work either. Is this feature still available? If
not, can we have it back?

...

Thanks for the feedback, everyone. It does indeed look like a forgotten
feature - I'll post it in Connect. Alex - yes, my workaround involves
using dimension security to restrict all the members on my dimension
then use a perspective to hide the dimension itself.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks Deepak!

Sadly the workaround isn't good enough! So I hope there'll be lots of votes
on:
https://connect.microsoft.com/SQLSer...dbackID=233410
- for a better solution in the future...

Best, Jocke

"Deepak Puri" wrote: