Here is the situation
We have product dimension and we want product sales
aggregated weekly or monthly i.e level could be diferent
But the complex part is we want it between specific dates
and those dates will be specified from app


Equivalent in sql:
Where date between begindate and enddate

How to acheive this in MDX
Regards,
AK

You need to create calculated member, such as

WITH MEMBER Measures.X AS 'Aggregate( Time.StartDate : Time.EndDate,
Measures.Sales ) '
SELECT SomeProducts ON 0
FROM Sales
WHERE Measures.X

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"akshayk" <akshay349 (AT) hotmail (DOT) com> wrote