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

PivotGrid and odata service

1 Answer 123 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
KRVC
Top achievements
Rank 1
KRVC asked on 02 Sep 2014, 04:47 PM
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. 

1 Answer, 1 is accepted

Sort by
0
Georgi Krustev
Telerik team
answered on 03 Sep 2014, 02:23 PM
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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
Tags
PivotGrid
Asked by
KRVC
Top achievements
Rank 1
Answers by
Georgi Krustev
Telerik team
Share this question
or