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: http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17.