PivotGrid and odata service

2 posts, 0 answers
  1. KRVC
    KRVC avatar
    3 posts
    Member since:
    May 2007

    Posted 02 Sep 2014 Link to this post

    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. 
  2. Georgi Krustev
    Georgi Krustev avatar
    3687 posts

    Posted 03 Sep 2014 Link to this post

    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.

    Georgi Krustev
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Back to Top