The MVC Pivot Grid extension allows you to visualize data contained in a cube deployed on an OLAP server. The OLAP data source delegates data management operations (such as summarization, grouping and so on) to an OLAP server and thus reduces the computing load on the web server. The Pivot Grid can use an ordinary server, http server, or cube file as a data source.
No model is required to establish an OLAP connection. Just provide a connection string with the PivotGridExtension.BindToOLAP method.
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
The source code files for this demo are installed (by default) in the following directory:
Open CS Solution
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxPivotGridDemos