New to Telerik UI for WPF? Download free 30-day trial

Load on Demand

The load on demand feature allows you to fetch the needed data only when the associated group gets expanded.

By default the OLAP data providers (XmlaDataProvider and AdomdDataProvider) will pre-load all the data from the associated cube and display it in the PivotGrid. To change this behavior, set the EnableLoadOnDemand property of the data provider to true. In that case, all groups will be collapsed initially and only the data that should be displayed at this state is fetched from the cube. On expand of a group (on demand), a new query is generated to load the data for the currently expanded groups.

 <pivot:XmlaDataProvider x:Key="XMLADataProvider" EnableLoadOnDemand="True"/>  

The expand behavior is not supported when the load on demand feature is enabled.

See Also

In this article