Date Range in MDX

Last Post 06 Jul 2004 06:22 PM by razza. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Mesalem
New Member
New Member

--
06 Jan 2004 01:09 AM
Hi all,
i have troubles with specifying date ranges in MDX
i can't use startdate:enddate expression because both the startdate and enddate must be members in the time dimension

i created a member property "The Date" for the Day Level and this property contains the date , i want to use something like this
Filter( {[Time].[Day].Members},([Time].CurrentMember.Properties("The Date") > startdate ) AND ([MyTime].CurrentMember.Properties("The Date") < enddate))

but this doesn't return the expected results

any solution for this problem?

thanks ,
Mohamed Mesalem

razza
New Member
New Member

--
06 Jul 2004 06:22 PM
Did you find a solution to your problem?

I have a similar problem where the users select a date range and often the dates selected do not exist in my Time dimension (creating an error).
You are not authorized to post a reply.

Acceptable Use Policy