Possibly the most important ASPxPivotGrid functionality is OLAP support. The ASPxPivotGrid
supports Microsoft Analysis Services 2000, 2005, 2008, 2008 R2, 2012 and 2014. As a data source, it can use an
ordinary server, http server or cube file.
To create an OLAP connection in code, you need to specify a connection string via the
At design time, you can build the connection string via the Connection String Editor available via the
in the Properties grid.
To connect to OLAP cubes, make sure that Microsoft Analysis Services OLE DB Provider for SQL Server 2014 is installed on your system. You can get the latest version of this provider here: