Hi all,

I am desperately to write this query...

Here's the algorithm:

If [Time Calendar].CurrentMember.Level is [Time Calendar].[Month] Then

LastPeriods(12, [Time Calendar].CurrentMember)

Else if [Time Calendar].[CurrentMember].Level is [Time Calendar Quarter]
Then

Sum(QTD([Time Fiscal].CurrentMember),[Time Series].[Value] )

In English, if a member in the time dimension is at the month level,
then we roll back by 12 months. If the member is at the Quarter level,
then I want the QTD of that quarter.

I hope this makes sense,

Audrey




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

It's not clear why you want QTD for a quarter, since that's the value
for that quarter. With that in mind:

is [Time Calendar].[Month],
Sum(LastPeriods(12,[Time Calendar].CurrentMember),
Time Series].[Value]),
Time Series].[Value])


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!