Comparison Operator for >= when connecting to Cube

3 posts, 0 answers
  1. devs
    devs avatar
    1 posts
    Member since:
    May 2013

    Posted 20 Sep 2015 Link to this post

    Hi, 

     

    I've been through all of the documentation I can find and I can't find any reference to filtering dates with a gte (>=) operator in the Pivot Grids.

    We use gte operator for a date field, in the Grids, to filter the data but have been unable to find a way to do this for the Pivot Grids when connected to the Cube.

     

    Is this possible?

    What we are basically trying to do is say, where [MatchDate].[CalendarDate], operator:"gte",  "01/08/2015".

     

    Regards,

    Kim

  2. T. Tsonev
    Admin
    T. Tsonev avatar
    2770 posts

    Posted 23 Sep 2015 Link to this post

    Hi,

    I'm too having trouble finding documentation on the PivotGrid filtering functionality. The most relevant resource is Filter a dimension.

    I'll request more information for the developers and we'll get back to you. Apologies for the caused inconvenience.

    Regards,
    T. Tsonev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
  4. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3706 posts

    Posted 28 Sep 2015 Link to this post

    Hello Kim,

    The PivotGrid does not have a notion for Date objects, but it considers them string values. That being said, the widget will create the XMLA request based on this rules. For instance, if you filter the [Date].[Calendar] dimension by "CY 2005" and "CY 2010", then the widget will generate the following XMLA request:
    ...
    SELECT ({[Date].[Calendar].[Calendar Year].&[2005],[Date].[Calendar].[Calendar Year].&[2010]}
    ...
    You can see this in our Basic Usage demo.

    That being said, the "greater than" will not be valid operator. The valid operators are shown in the Filter UI popup menu "Fields filter". You can see them in the Basic Usage demo.

    Regards,
    Georgi Krustev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top