Hi,
I have an MSAS 2000 dynamic security implementation which is a slight
variation on the virtual cube method.

Is there a whitepaper or anything I can refer to when reimplementing
this in SSAS 2005? Also, any 2005 dynamic security sample code would be
VERY helpful!

Thanks,
Scott

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

Reed Jacobson of Hitachi Consulting has written a nice article on SSAS
2005 Dynamic Security. Here's the link:

http://sqljunkies.com/WebLog/hitachi.../29/23048.aspx.

Also, the book Applied Analysis Services by Teo Lachev has a good
chapter with code on how to implement it.


Scott Sampson wrote:

I have implemented Dynamic Security using a .Net assembly and it works
great - albeit a little slower. The vb.Net assembly takes the username
and looks up a db table to find the relevant dimension member to allow
/ deny. I have as a result reduced the number of roles i previously had
from about 200 to 2.

a