Hi

Im trying to set a default member for a dimension using a MDX expression:

This is what i would like to do but it does not work:
Filter([Consultant].Members,[Consultant].CurrentMember.Properties("LoginName")
= UserName)

But if i dont use Currentmember it works fine:
Filter([Consultant].Members,[Consultant].[JAOR].Properties("LoginName") =
UserName)

why can i use CurrentMember here? Any workaround?

thanks

Jan

Are you sure that every member has such a member property? Even the ALL
level (if enabled)? :-)
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jan Frandegard" <jan.frandegard (AT) dspanel (DOT) com> wrote

")

You'r right here, it works fine if we disable the "All Level". But how
should we do it if we want the "All Level" to be available? Is it possible
to add member properties to the "All level"?

/Christer

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Forget my last question... We should of course use children on the "All
level" instead of all membes for the dimension...

:-) Christer

"Christer K" <a@b.com> wrote