Calculating QTD - Help

Hi,

Can anyone help me in calculating QTD for a particular measure? Some example on QTD calculation would be helpful.

In SSAS2005 you can try this:

SUM(QTD(MyTimeDim.MyTimeHierarchy.Month.CurrentMember), Measure.MyMeasure)

In AS2000 you can try this:

SUM(QTD(MyTimeDim.Month.CurrentMember), Measure.MyMeasure)

These are very simple examples to get you going.

Here is a link to a good article about MDX-time functions:

http://www.databasejournal.com/features/mssql/article.php/2232111

HTH

Thomas Ivarsson