Change Theme Settings
Change Theme Settings
Show All Themes

OLAP Browser


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 OLAPConnectionString property. At design time, you can build the connection string via the Connection String Editor available via the OLAPConnectionString property 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:

See Also: