Re: About Calculated Members

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

From: Francesco De Chirico (f.dechirico_at_forgroup.it)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 18:33:47 +0200

Hi Ricardo,
if I understand, you want to test if the actual member is the member you
want??
You can't reference to the CurrentMember of a level, but you can reference
to the CurrentMember of the dimension, so, you can use:

IIF( [Products].CurrentMember is [Products].[Type].&[Fruits], 1, 0)

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)
  • Default Member Property
    ... Im trying to set a default member for a dimension using a MDX expression: ... But if i dont use Currentmember it works fine: ...
    (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)
  • Re: relating two tables with common field but not seeing data in forms.
    ... >this should bring up the query design grid with your two tables shown. ... >database table when you get a new csv file. ... >> member datafields to each record. ... >> example, to keep it simple, one reference number field and name field. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Dumb Question About External References
    ... The ccp_01 class doesn't have a IsPostback member! ... Cannot access a nonstatic member of outer type 'ASP.ViewState02_aspx' ... An object reference is required for the nonstatic field, method, ...
    (microsoft.public.dotnet.languages.csharp)