Hi,
I can't use any OLAP technologies in my project.
So we store our data in one huge flat table.
How can I make PivotGrid to send requests to my service and refresh itself whenever user drills down or deletes a column/row/measure without XMLA?
Currently I was able to configure datasource with type : 'odata'. But PivotGrid uses it only once to retrieve initial json list.
I can't use any OLAP technologies in my project.
So we store our data in one huge flat table.
How can I make PivotGrid to send requests to my service and refresh itself whenever user drills down or deletes a column/row/measure without XMLA?
Currently I was able to configure datasource with type : 'odata'. But PivotGrid uses it only once to retrieve initial json list.
1 Answer, 1 is accepted
0
Hello Egor,
Currently, the Kendo UI PivotGrid widget supports binding to SASS (or other OLAP technology) and to client-based data cube. When pivotgrid is bound to a flat data, it creates a cube (categorized data) on the client and then uses it to slice and dice. It requires the whole data in order to build the correct data cube. This is mentioned in the FAQ section of the pivotgrid.
Server-based data cube is not supported, as it will need to categorize the data on the server and most importantly to understand MDX queries, which on one way or another overlaps the OLAP technology.
Regards,
Georgi Krustev
Telerik
Currently, the Kendo UI PivotGrid widget supports binding to SASS (or other OLAP technology) and to client-based data cube. When pivotgrid is bound to a flat data, it creates a cube (categorized data) on the client and then uses it to slice and dice. It requires the whole data in order to build the correct data cube. This is mentioned in the FAQ section of the pivotgrid.
Server-based data cube is not supported, as it will need to categorize the data on the server and most importantly to understand MDX queries, which on one way or another overlaps the OLAP technology.
Regards,
Georgi Krustev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!