dbTalk Databases Forums  

Retrieve dimensions when a dimension is restricted for a particular role

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


Discuss Retrieve dimensions when a dimension is restricted for a particular role in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Usmani
 
Posts: n/a

Default Retrieve dimensions when a dimension is restricted for a particular role - 05-19-2005 , 05:28 AM






Hi,
I have fully restricted Position dimension in cube HR for a particular
user role in MS Analysis Manager.
Now when I discover dimensions by XMLA with a user included in that
role, I receive all dimensions but the levels for Position dimension
are not retrieved. If I want only those dimensions that are accessible
to user I have to query OLAP three times i.e. for dimension, for
hierarchies and than for levels (if levels are not retrieved it is
assumed that the dimension is restricted). Is there something that I
can add to the message in restriction list so that when I discover the
dimensions, MSOLAP do not send me the dimensions that are fully
restricted?

Thanks
Usmani


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.