The Kendo UI PivotGrid is a powerful data visualization component allowing developers to perform operations over multi-dimensional/ pivot data. The widget uses the Online Analytical Processing (OLAP) approach to present the result of multidimensional queries in a comprehensive way. Populate Kendo UI PivotGrid to OLAP cube or service which implements XMLA standard to easily display, sort, page and filter data from your Cube.
Adding the HTML5 PivotGrid widget to your applications, allows you to build basic BI capabilities into your web-based applications. You can enable the filtering mechanism in PivotGrid via the API configuration and thus, let your end-users filter their data in Excel-like manner.
The widget supports passing JSON array as data source which to be transformed into OLAP cube on-the-fly and displayed in the PivotGrid. This is useful when you do not need the full power of the standard OLAP cube’s data processing capabilities, and intend to operate with small to medium amount of data items.
PivotGrid lets end users manipulate huge amounts of data. In case this data can't fit on one page, the widget also supports scrolling and frozen header rows.