dbTalk Databases Forums  

URGENT: AS2005 & Security... how to completly hide a dimension for a role????

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss URGENT: AS2005 & Security... how to completly hide a dimension for a role???? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default URGENT: AS2005 & Security... how to completly hide a dimension for a role???? - 05-19-2006 , 08:02 AM






Hi,

I have a cube where I'm using 2 times the same dimension (source
organization and Destination organization share the same dimension:
Organization)
I try to create a role to disallow access to the Destination organization in
this cube.
but there is no way do this!!!

In AS2000 I can setup some option to completly restrict the access to a
dimension, but now I can't the user will see the dimension.

I can disallow access to the content of the dimension, but the user see the
metadata, so the user see the "Destination Organization" dimension and I
don't want this!!!!

what can I do?????
The only solution I can see is creating a new cube linked to the first one
and remove the dimension in this cube. but its NOT a solution.

A quick answer will be helpfull.

Thanks.

Jerome.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.