This is a migrated thread and some comments may be shown as answers.

Comparison Operator for >= when connecting to Cube

2 Answers 44 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
devs
Top achievements
Rank 1
devs asked on 20 Sep 2015, 08:39 PM

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 Answers, 1 is accepted

Sort by
0
T. Tsonev
Telerik team
answered on 23 Sep 2015, 01:40 PM
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!
 
0
Georgi Krustev
Telerik team
answered on 28 Sep 2015, 11:14 AM
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!
 
Tags
PivotGrid
Asked by
devs
Top achievements
Rank 1
Answers by
T. Tsonev
Telerik team
Georgi Krustev
Telerik team
Share this question
or