i have a formula like below(Time dimension Year-Quarter-Month; from 2003 to
2005):
(([Dim DM Time].currentmember.prevmember,[Measures].[Upb])-([Dim DM
Time].currentmember,[Measures].[Upb]))/([Dim DM
Time].currentmember.prevmember,[Measures].[Upb])

the problem is for the root level (like January in 2003 then there shouldn't
have any value returned since no previous UPB; the same for the 1st quarter
of 2003, the year of 2003 and grand total for all; but how can i fix the
display problem in OLAP and Pivot table?

thanks a lot

You could do something like

IIF(FistSibling([Dim DM Time].currentmember) is [Dim DM
Time].currentmember.prevmember, 0,
(([Dim DM Time].currentmember.prevmember,[Measures].[Upb])-([Dim DM
Time].currentmember,[Measures].[Upb]))/([Dim DM
Time].currentmember.prevmember,[Measures].[Upb]))

This would check to see if you are at the first member for that level and if
you are then return 0.

David Botzenhart

"urgent" <urgent (AT) discussions (DOT) microsoft.com> wrote

thanks. but the firstsibling will exclude all first
child(Jan,April,July,Oct) in every quarter of each year(2003,2004,2005)

is there anything else can get around? thanks.


"David Botzenhart" wrote: