This seem to be working... but I am a bit nervous.

I am trying to write the formula for "test". "test" is the calculated member
here but I am referencing "test" itself in the formula:

If at month level, add all QTY to be "test"
If at year level, the year "test" is the december "test" (LastChild)

Is it legal to use a calculated member itself in the formula that way?? Am I
looking for potential "weird" problems?

IIF([Time].CurrentMember.Level IS [Date].[Month],
Sum(PeriodsToDate([Time].[(All)], [Time].CurrentMember),[Measures].[QTY]),
IIF([Time].CurrentMember.Level IS
[Time].[Year],([Time].CurrentMember.LastChild,[Measures].[test])
,NULL))

Thanks for any advice.

This is a recursive calculated member definition, which can be used, for
example, to find the last non empty value:

http://msdn.microsoft.com/library/de.../en-us/dnsql2k
/html/semiadd2.asp

Amir Netz
Microsoft Corporation

Updated May 18, 2004

Applies to:
Microsoft SQL Server 2000
Microsoft SQL Server 2000 Analysis Services

Summary: Focusing on a classic inventory problem, this article describes
the implementation techniques of semiadditive measures in online
analytical processing.
...
Measures.[Last Non Empty Value]:
CoalesceEmpty((Measures.[Value], Time.CurrentMember ) ,
(Measures.[Last Non Empty Value],Time.CurrentMember.PrevMember))
There needs to be a recursion termination condition.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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