Re: Using user defined function to manage security

#1

Øyvind wrote:

Quote:

I am trying to use an user defined function "Security" that will
return an mdx expression, lets say {[CostPlace].[Bu
Level].&[Adviso]}. I add this function to a new database role in
Analysis server, under the advanced tab in the "Custom Dimension
Security:CostPlace" window. In the Allowed members textbox I add
Security(), after registering the component in the mdx builder. When
I then click OK in the "Custom Dimension Security" I get the
following error message:

"Dimension security syntax error:
Formula error - cannot convert expression to expression to Set - in a
user-defined function Do you still want to use this expression for
dimension security "

I have hard coded the function to return the string "{[CostPlace].[Bu
Level].&[Adviso]}", and if I put this line in the allowed member
textbox directly it works fine.

I have upgraded the Analysis Services to build 8.0.940.0 (the latest
build available), which is running on a win2000 SP4 server.

Anybody knows what could be the problem?

Did you try StrToSet( Security() ) instead?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Using user defined function to manage security

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

Re: Using user defined function to manage security - 06-02-2004 , 05:46 AM