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)

Old one, SSAS 2000, How to calculate Net Value By Date (NetValue / Date)

Other source from MSDN
http://msdn.microsoft.com/en-us/library/ms146067.aspx

Leave A Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.