Lazy loading support PivotGrid MVC

[sandeep]

Hello,

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? 

Thanks,
-Sandeep

[Polya]

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:
http://feedback.telerik.com/Project/143/Feedback/Details/113798-configuring-pivotgrid-without-pivotfieldlist

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:
http://feedback.telerik.com/Project/143#

Regards,
Polya
Telerik