In real world ,a frequent requirement is to get measure values
in a given date range which could or could not span entire year.
E.g I want to show monthly sales of products between
2002-10-23 23:11:00 to 2003-2-24 11:11:00

Now the data range is specified with hours. Even if we ignore hours , date
range is specified at lower level
where as data at monthly or weekly level might be required.
How do we handle this in MDX ?
Regards,
Akshay

WITH MEMBER MEASURES.[SALES WITHIN DATE RANGE] AS '
SUM(intersect(descendants([TIME_DIM].currentmember, TDATE, SELF),
{[TIME_DIM].[TDATE].[1998-01-24 00:00:00] :
[TIME_DIM].[TDATE].[1998-04-15 00:00:00]}), MEASURES.[SALES])'
SELECT MEASURES.ALLMEMBERS ON COLUMNS,
[TIME_DIM].[MONTH].MEMBERS ON ROWS FROM MCUBE

you can replace the [MONHT] with any level you like in last line

Please Please Please let me know if this worked for you or not in both
cases.

Thanks,

Asim Naveed.

--
Posted via http://dbforums.com

This works thank you man
"asim73" <member31195 (AT) dbforums (DOT) com> wrote