Hi:

I am trying to find the first month in the time dimension where a
particular measure has no value.

E.g. Jan06 is the last month that I have data in the unit, so I want
the time dimension to return me Jan06 as a default member.

I try to use this MDX
head(Filter([Time].[Mo Short Name].Members,NOT
IsEmpty(Time.CurrentMember)),1).Item(0)

But, this will only work when all the measures that associate with it
has no value. I have plan # for the rest of the year.

How do I specifically say that if the [measure].[unit] is empty then
retrun me the head of the set.

Thanks
Arale

How about:

Head(Filter([Time].[Mo Short Name].Members,NOT
IsEmpty([Measures].[unit])),1).Item(0)


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Hi Deepak:

Thanks for the reply. I try, but it doesn't work. It gives me the
last child in the time hierarchy. (which has the plan number, but 0
unit)

Thanks

Hi,

Try instead of IsEmpty(Time.CurrentMember)
this IsEmpty(Time.CurrentMember, [measure].[unit])

Using

NonEmptyCrossjoin([Time].[Mo Short Name].Members, {[measure].[unit]}, 1)

instead of

Filter([Time].[Mo Short Name].Members,NOT
IsEmpty(Time.CurrentMember)),1)

would be more quickly.

Thanks,
Vladimir Chtepa


<aralew (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1136922846.545069.25890 (AT) z14g2000cwz (DOT) googlegroups.com...

Well, if you really want to exclude 0, that's not necessarily the same
as empty, so maybe try:

[Measures].[unit] > 0),1).Item(0)


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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