Re: Check whether current dimension member is Allowed/Denied

#1

Hi JeJe,

The IsError Construct worked. I had to use
StrToSet(IIF(ISERROR(StrToValue("[Metrics].&[M0010]")),
"{"[Metrics].&[M0000]}", "{[Metrics].&[[M0010]}"))

Thanks for your help.

Regards
Venkatesh.
"Jéjé" wrote:

Quote:

and anything like:
iif(iserror(strtomember("[Metrics].&[M0010]"))

or
iif(count(filter([Metrics].members, [Metrics].currentmember.key = "M0010"))
= 0

vvenkie (AT) gmail (DOT) com> wrote in message
news:1124912829.960388.78330 (AT) g43g2000cwa (DOT) googlegroups.com...
I tried the function. It doesn't work.

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

Re: Check whether current dimension member is Allowed/Denied

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

Re: Check whether current dimension member is Allowed/Denied - 08-25-2005 , 12:10 PM