Possibly the most important ASPxPivotGrid functionality is OLAP support. The ASPxPivotGrid
supports both Microsoft Analysis Services 2000, 2005, 2008 and 2008 R2. As a data source, it can use an
ordinary server, http server or cube file. The OLAP connection reduces the computing load
on clients by passing it to a remote server.
The creation of an OLAP connection is not a common task. Here you don't need to set the DataSourceID
property, but you should specify a correct connection string in the OLAPConnectionString property. To
accomplish this in the easiest way possible, click the ellipsis button next to the property value in
the property grid. This will invoke the connection string designer that will help you setup the connection.
To connect to olap cubes, you should have Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB
Provider installed on your system. You can get the latest version of this provider here: