Default Member Property

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jan Frandegard (jan.frandegard_at_dspanel.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 10:20:53 +0200

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

Relevant Pages

  • Re: How to identify set (similar as possible)
    ... currentmember always return a member, ... using the extract function on a set when you don't know if the set contain ... this dimension or not raise an error when the dimension is not here. ...
    (microsoft.public.sqlserver.olap)
  • Re: Calculated Member solution (Dave, Deepak)
    ... option might be to check if the current Gender dimension is not the ... > member (MDX Expression) depends upon whether a particular dimension say ...
    (microsoft.public.sqlserver.olap)
  • Re: About Calculated Members
    ... I tried what you said, but it works only when I filter in that specific dimension or when I show that specific dimension, but the "All Products" returns zero ... you want to test if the actual member is the member you ... > You can't reference to the CurrentMember of a level, ...
    (microsoft.public.sqlserver.olap)
  • Comparing a Date to Time Dimension Members
    ... In a MDX expression, During iteration through a set of the time ... dimension, how can I test at each step if the current ... member is greater than a specified value (January ...
    (microsoft.public.sqlserver.olap)
  • Re: About Calculated Members
    ... you want to test if the actual member is the member you ... You can't reference to the CurrentMember of a level, ... to the CurrentMember of the dimension, so, you can use: ...
    (microsoft.public.sqlserver.olap)