The Web Forms Pivot Grid control allows you to visualize data contained in a cube deployed on an OLAP server. The OLAP data source delegates data management operations (such as summarization, grouping and so on) to an OLAP server and thus reduces the computing load on the web server. The Pivot Grid can use an ordinary server, http server, or cube file as a data source.
No model is required to establish an OLAP connection. Just provide a connection string with the ASPxPivotGrid.OLAPConnectionString property.
The Pivot Grid supports OLAP servers and providers listed in the Supported OLAP Servers and OLAP Data Providers topics.