Testing default member using member prop

#1

filter([Userdim].[Username].members,[Userdim].currentmember.properties("NtNa
me")="JoshNT")

This syntax is accepted in the default member box in the dimension but
nothing happens when looking at the cube - what is wrong ?

#2

Filter() returns a set, not a member. Will this work?

Quote:

filter([Userdim].[Username].members,[Userdim].currentmember.properties("

NtNa
me")="JoshNT").Item(0)

Quote:

- Deepak

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

#3

And so it did...

Thanks Deepak

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Quote:

Filter() returns a set, not a member. Will this work?

filter([Userdim].[Username].members,[Userdim].currentmember.properties("
NtNa
me")="JoshNT").Item(0)

- 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

Testing default member using member prop

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

Testing default member using member prop - 11-22-2004 , 12:54 PM

Re: Testing default member using member prop - 11-22-2004 , 03:40 PM

Re: Testing default member using member prop - 11-23-2004 , 01:53 PM