Depending on whether you wish to analyze just one measure or many, you
can either set up calculated measures or a time-analysis dimension. A
calculated measure might be:

'[Measures].[Unit Sales] - ([Measures].[Unit Sales],
ParallelPeriod([Time].[Quarter]))'

Select {[Measures].[Unit Sales],
[Measures].[QuarterlySalesChange]} on columns,
[Time].[Month].Members on rows
from Sales

A KB article shows how to create analytical dimensions:

http://support.microsoft.com/default...;EN-US;q304118
Article ID : 304118
Last Review : July 15, 2004
Revision : 1.0
This article was previously published under Q304118

SUMMARY
Time series calculations are frequently required in business and
financial reports. Multidimensional expressions (MDX) provide the
following time oriented functions to perform time series calculations: •
YTD
• QTD
• MTD
• WTD
• LastPeriods
• PeriodsToDate
This article describes how to use the functions in the preceding list to
provide year-to-date, quarter-to-date, month-to-date, and 12 month
moving total calculations.
...

And here is a link to download such a sample:

http://www.tomchester.net/articlesdo...dimension.html


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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