Hi,

I have read the great presentation on implementing Dynamic Security roles
with UDF and other techniques.

My question is, when is this solution required? I guess nobody would bother
doing this for a couple of different users. How many different roles can be
smoothly supported in AS 2000 (and AS 2005) without implementing dynamic
security?

Thanks,
Stan

Maybe a couple of hundred. But remember even for a few there are still good
reasons to go with dynamic security, particular the UDF version.
Administration is offloaded and the changes happen right away without any
reprocessing on the AS-side.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Stan Kondrat" <StanKondrat (AT) discussions (DOT) microsoft.com> wrote

In As2000 we found serious performance limitations as the number of roles
grew past about 25. However, the performance hit wasn't in executing
queries, it was in processing/saving the cube. Haven't tested this yet in
2005.

Dynamic security is good stuff.

"Stan Kondrat" wrote: