dbTalk Databases Forums  

Re: Dimension Securty and DrillThrough

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


Discuss Re: Dimension Securty and DrillThrough in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: Dimension Securty and DrillThrough - 12-26-2005 , 06:40 PM






1. You cannot use drill through when you slice on the members which are
_above_ the secured members. As soon as you drill down to the members at
lower levels and there are no secured members below them - drillthrough will
work.
2. The above limitation only applies to the previous version - i.e. to
Analysis Services 2000. In Analysis Services 2005, drillthrough will work
fine if invoked on any cell.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Fernando Marçal" <FernandoMaral (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,

I have a dimension, on which I've restricted access to certain members.
After I restrict access to those members I am no longer able to perform
drillthrough on a cube that contains that dimension, even if that
dimension
is not being used on an axis...

Is this the default behaviour? If not, what can be done?

Thanks!



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.