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.
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI