The PivotGrid for ASP.NET MVC supports Ajax data binding to an HTTP accessible Online Analytical Processing (OLAP) cube and to flat data.
Telerik UI provides an OLAP service dll that can be used for testing and is hosted at
https://demos.telerik.com/olap/msmdpump.dll. To see the responses, the service needs to be queried and cannot be opened directly in the browser. For more information on binding the PivotGrid to data over an OLAP cube, refer to the following articles:
When the PivotGrid is bound to flat data, it creates a client-side cube which allows the categorization of the flat data. For runnable examples on binding the PivotGrid to flat data, refer to the following online demos:
- Local binding of the PivotGrid HtmlHelper for ASP.NET MVC (Demo)
- Remote binding of the PivotGrid HtmlHelper for ASP.NET MVC (Demo)