I am trying to get an average of a month over multiple years using mdx.
e.g.
if my currentmember is 'F06 Aug' I would like to get the AVG(F05
Aug,F04 Aug, F03 Aug,...)

any help will be appreciated.

Ali Rizvi

Are you using AS 2000 or AS 2005? With AS 2005, the simplest solution
would be to include a "Month of Year" attribute, as in the Adventure
Works date dimension:

Avg(Exists([Date].[Calendar].[Month].Members,
Existing [Date].[Month of Year].Members),
[Measures].[Order Quantity])
select {[Measures].[Order Quantity],
[Measures].[AvgMonthOrders]} on 0,
[Date].[Calendar].[Month].Members on 1
from [Adventure Works]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***