It is likely that the most important MVC Pivot Grid functionality is OLAP support. MVC Pivot Grid supports both Microsoft Analysis Services 2000, 2005, 2008 and 2008 R2. It can use an ordinary server, http server or cube file as a datasource. The OLAP connection reduces the computing load on the web server by passing it to an OLAP server.
No model is required to establish an OLAP connection. All you need is to provide a connection string using the BindToOLAP method.
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.