September 11, 2008 at 8:51 am
Hi I have situation
I am trying to calculate lag period from the present quarter to last quarter
time hierarchy has
year(level1)
quarter(level2)
i wanted to see percent rejected measure in such a way that
2007Quarter4 -''percent rejected" shows 2007Quarter3 value
and
2007Quarter3 -''percent rejected" shows 2007Quarter2 value
2007Quarter4 -''percent rejected" shows 2007Quarter3 value
and
2007Quarter1 should show -''percent rejected" shows 2006Quarter4 value( I am not able to see these values
)
when I gave the above code:
( [Time].[TimeHierarchy].CurrentMember.Lag(1), [Measures].[percent rejected] )
this is fine with year level ,but at quarter level...for example 2008 Q1 is not picking up the value of 2007 Q4
it shows null values
when I try this above code
iif( [Time].[TimeHierarchy].CurrentMember.Level.Ordinal = 2, (([Time].[TimeHierarchy].CurrentMember.Lag(1)),[Measures].[percent rejected] ),
(([Time].
[TimeHierarchy].CurrentMember.Lag(1)), [Measures].[percent rejected] ))
still the same thing happens in the result
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply