The MDX script on Microsoft Analysis Service (SSAS) 2008 and 2005 are different from SQL 2000. Here’s an example how to calculate average using MDX script on Analysis Service 2008.
SSAS 2008, How to calculate Net Value By Date (NetValue / Date)
|
1 2 3 4 5 6 7 |
AVG( Descendants( [Time].[Calendar].CurrentMember, [Time].[Calendar].[Date] ), [Measures].[NetValue] ) |
Old one, SSAS 2000, How to calculate Net Value By Date (NetValue / Date)
|
1 2 3 4 5 6 |
AVG( Descendants( [Time].CurrentMember, [Date] ), [Measures].[NetValue] ) |
Other source from MSDN
http://msdn.microsoft.com/en-us/library/ms146067.aspx