The PivotGrid supports OLAP services (MS SQL Server Analysis Services). This allows you to deliver solutions that can easily analyze millions of data rows within your app. In this demo, the PivotGrid uses XmlaStore to connect the UI component to a sample remote OLAP service. The Field Chooser is configured to show the search box to speed up choosing the required field.