Dynamic roles Olap 2000 SP3 with UDF

#1

Hi all
I'm tring to impliment dynamic roles with UDF.
My functions returns a string represent a member of restricted dimension
(Like: [MyDimension].[LevelName].&[1]).
When i register the function and use it in a calculated member, i get what i
want (a string contains the member), but when i use it in dimension role (by
using custom option), the olap cannot find the member and the error message
"The dimension "MyDimension" has no valid member...".
if I take the member as string from the calculated member and write it in
the custom option it workes (hard coded).

Thanks

#2

Shalom Shlomi
I have the same problem.
The following link is usefull.
Seems like a patch you need to install:
http://www.mosha.com/msolap/samples/...20security.zip

"Shlomi" wrote:

Quote:

Hi all
I'm tring to impliment dynamic roles with UDF.
My functions returns a string represent a member of restricted dimension
(Like: [MyDimension].[LevelName].&[1]).
When i register the function and use it in a calculated member, i get what i
want (a string contains the member), but when i use it in dimension role (by
using custom option), the olap cannot find the member and the error message
"The dimension "MyDimension" has no valid member...".
if I take the member as string from the calculated member and write it in
the custom option it workes (hard coded).

Thanks

#3

Toda Rea
we solved it out. the problem was fixed in SP4 for SQL2000 (or with the
patch).
our dynamic security works fine...
thank you anyway...

Shlomi

"Rea" wrote:

Quote:

Shalom Shlomi
I have the same problem.
The following link is usefull.
Seems like a patch you need to install:
http://www.mosha.com/msolap/samples/...20security.zip

"Shlomi" wrote:

Hi all
I'm tring to impliment dynamic roles with UDF.
My functions returns a string represent a member of restricted dimension
(Like: [MyDimension].[LevelName].&[1]).
When i register the function and use it in a calculated member, i get what i
want (a string contains the member), but when i use it in dimension role (by
using custom option), the olap cannot find the member and the error message
"The dimension "MyDimension" has no valid member...".
if I take the member as string from the calculated member and write it in
the custom option it workes (hard coded).

Thanks

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

Dynamic roles Olap 2000 SP3 with UDF

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

Dynamic roles Olap 2000 SP3 with UDF - 09-11-2005 , 03:50 AM

RE: Dynamic roles Olap 2000 SP3 with UDF - 12-05-2005 , 03:15 AM

RE: Dynamic roles Olap 2000 SP3 with UDF - 12-05-2005 , 03:23 AM