Dynamic Security

Hi,

I am a little concerned about the recent discussion of “Dynamic Security” and SSAS 2005.

http://blogs.proclarity.com/blogs/dgustafson/archive/2006/3/21/54.aspx

Is the “Dynamic Security” approach really scalable?

Christian

Don't take my post at blogs.proclarity.com the wrong way. This is not so much a performance problem in SSAS 2005. Rather, using dynamic security makes external OLAP query caching difficult for our product, ProClarity Analytics Server. My advice would be to think twice before using dynamic security to simply bypass the management of OLAP roles or AD groups.