Hi there,

I have recently set up Dynamic Security using one of the Microsoft suggestions from their WebCast on this subject (Fact Table approach).

This works very well, and within a general Cube, users only see the data for which they have been granted permission. The problem comes when they do a Drillthrough on the data - they get all of the data - i.e. with no restrictions.

As an example, I am filtering data by Geography. What is happening is that the user has access to one Geographical region (UK), but this is the only region shown within its Parent (World), so when Analysis Services performs the Drillthrough, it takes the Parent value, searches by World and presents a security problem as it gives all data.

Any suggestions on how to overcome this would be most welcome.

Many thanks,

Nigel.