PDA

View Full Version : MDX question



abz_diego
10-15-2003, 05:21 AM
i have the following query:
with member [Measures].[birth_date] as '[customer].CurrentMember.Properties("birth_date")'
select { [Measures].[sales]} ON columns,
filter(Descendants([customer].CurrentMember, 3), [Measures].[birth_date] > '02-02-2001') ON rows
from [sales]
Birth date in my database is "date type". it is posible to have a comparison of [Measures].[birth_date] > '02-02-2001' ?
there is another solution for do that?

jhyde
10-15-2003, 12:35 PM
Mondrian doesn't have any date functions, I'm afraid. The best I can suggest is that you convert the date column to a string value on which you can do string comparison, that is, '2001-02-21'.