I have seen this before but have forgotten how it hangs together.. perhaps
someone with better memory could help :-)

I have fact data captured per quarter, it obviously doesn't make sense to
just some this up if looking it at from the Year dimension.. what I want to
do is just take the value at the last quarter for that year.. if looking at
the value finer grained than a quarter, say month, I want to just take the
value for the quarter preceding that month..

How do can I navigate back and forward and up and down the Time dimesion
like this?

I presume I start with something like

iif(Time.CurrentMember.Level.Name = "Year"...

thanks

Hi Giri,

I am afraid that I do not understand you quite well. Are you writing an MDX
based on a cube? Also what is the meaning of "How do can I navigate back
and forward and up and down the Time dimesion like this?" Can you
illustrate with some sample data?

Have you checked LastChild function?

Bill Cheng
Microsoft Online Partner Support
Get Secure! – www.microsoft.com/security
This posting is provided “as is” with no warranties and confers no rights.
--------------------
.phx.gbl

Don't worry sorted it out after digging around myself..

Used Dim.CurrentMember.Level.Name to check to see what level it was and then
used a mix of Parent, LastChild etc..

Thanks anyway

""Bill Cheng"" <billchng (AT) online (DOT) microsoft.com> wrote