Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: MDX question

  1. #1
    Join Date
    May 2003
    Posts
    22

    Default MDX question

    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?

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: MDX question

    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'.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.