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 (
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.