Hi

I like to use calc measures to display member properties. How come this
don't work:

iif([RammeDelKontoAkt].currentmember.level.ordinal =
1,[RammeDelKontoAkt].currentmember.properties("Antal Poster")+" poster i
"+[RammeDelKontoAkt].currentmember.properties("Måned")+"/
"+[RammeDelKontoAkt].currentmember.properties("År"),null)

...but this does

iif([RammeDelKontoAkt].currentmember.level.ordinal =
1,[RammeDelKontoAkt].currentmember.properties("Antal Poster")+" poster i
"+[RammeDelKontoAkt].currentmember.properties("Måned")+"/
"+[RammeDelKontoAkt].currentmember.properties("År"),"")

That actually bugs me.....the last one isn't what I want - because "" will
display empty cells as well.

Are there any other ways to do this ?

http://groups-beta.google.com/group/...rver.olap/msg/
cec78b442eb1c21e
From: Deepak Puri <deepak_p... (AT) progressive (DOT) com>
Date: Wed, 20 Apr 2005 14:42:26 -0700
Subject: Re: iif() problem

There is a well-known issue when combining a string with NULL in iif(),
which you may be encountering. Using a second measure to "hide" the text
may work, like:

[Measures].[Text1] :

Right([Measures].[Codigo Data Venc Titulo],2) + "/" +
Mid([Measures].[Codigo Data Venc Titulo], 5, 2) + "/" +
Left([Measures].[Codigo Data Venc Titulo],4)


[Measures].[Text2] :

iif(IsEmpty([Measures].[Codigo Data Venc Titulo]),
NULL, [Measures].[Text1])
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanx Deepak

That worked...I actually did try the second measure by saying = "" but I had
to use the ISEMPTY instead.


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