Lazy loading support PivotGrid MVC

2 posts, 0 answers
  1. sandeep
    sandeep avatar
    1 posts
    Member since:
    Apr 2016

    Posted 07 Apr 2016 Link to this post


    I have been evaluating PivotGrid control and I saw (through Fiddler) that the way the PivotGrid loads data  was using Eager Load pattern even though I set my pivotgrid rows and columns to collapse. This approach I think will have performance impact at inital load especially if the cube I'm trying to browse is a large cube. Is there a way to set the pivot grid to use Lazy Loadpattern? 

  2. Polya
    Polya avatar
    267 posts

    Posted 08 Apr 2016 Link to this post

    Hi Sandeep,

    You are, indeed, correct - with the current implementation of RadPivotGrid the query passed to the cube extracts the whole data that matches the set OlapDataProvider settings.
    The expand/collapse state of the RadPivotGrid is responsible only for the UI representation of the data and is not included in the filtering of the data. 

    Currently the DataProvider can be configured through the UI only by using a RadPivotFieldList (and it cannot be configured using a RadPivotGrid). We have a feature request logged about this:

    After implementing the above feature - an expand/collapse filtering of the mdx query could be included as an additional filtering functionality.
    I suggest logging it as a feature request in our Feedback Portal where you can track its progress and vote for it:

    Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Back to Top