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.