Re: Does StrToMember Return a Member Object?

#1

I can't explain why applying .Level didn't work. But when I searched
this Newsgroup, I found an Oct. 14 2002 thread that discussed the
inconsistent behavior of StrToMember(). There, George Spofford suggested
using Members() instead.

In your example, this seems to work: Test4 =
Members("[Product].[Product Family].[Drink]").Level.Name

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#2

Thanks Deepak. Worked like a charm!!

Dave F.

Quote:

-----Original Message-----
I can't explain why applying .Level didn't work. But
when I searched
this Newsgroup, I found an Oct. 14 2002 thread that
discussed the
inconsistent behavior of StrToMember(). There, George
Spofford suggested
using Members() instead.

In your example, this seems to work: Test4 =
Members("[Product].[Product Family].[Drink]").Level.Name

- Deepak

*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.

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

Re: Does StrToMember Return a Member Object?

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

Re: Does StrToMember Return a Member Object? - 08-13-2003 , 01:03 AM

Re: Does StrToMember Return a Member Object? - 08-15-2003 , 07:38 AM