Comparison Operator for >= when connecting to Cube

[devs]

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

[T. Tsonev]

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

 

 

[Georgi Krustev]

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