US and Worldwide: +1 (866) 660-7555
Results 1 to 4 of 4

Thread: Filter for Date or Time in Pentaho Analyser

  1. #1
    Join Date
    Apr 2013
    Posts
    11

    Question Filter for Date or Time in Pentaho Analyser

    Hi,

    I got a Mondrian Schema with some Date and Time Dimensions.
    Is there any possibility to filter a Range on Date or Time?
    When i try to add an Filter on such a Dimension i can only select items from the given values. But on 500 Entries for Dates that makes no sence



    Thx in advance.



    Regards,
    Student

  2. #2
    Join Date
    Jan 2013
    Posts
    548

    Default

    If you set type="TimeDimension" on your dimension, I believe you'll get additional options in the filter dialog- including ranges and relative time members.

    Take a look at the Time Dimensions section of the config guide: http://mondrian.pentaho.com/documentation/schema.php

    I think you'll also need to mark the levels with levelType (TimeQuarters, TimeMonths, etc.)

  3. #3
    Join Date
    Apr 2013
    Posts
    11

    Default

    thanks for your answer.

    If i get you right i have to declare the dimension type manually in the mondrian schema. Or is there any possibility to edit the dimension type in the web interface (analyser)?

    There are options to set a geographical type to the dimension, but not a special type like Time.


    Best Regards,
    student

  4. #4
    Join Date
    Jan 2013
    Posts
    548

    Default

    Yes, I believe it has to be done in the Mondrian schema. See http://infocenter.pentaho.com/help/i...e_filters.html

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •