Currently Pivot Grid has very limited support for flat data. Please include a library so we can emulate OLAP on the MVC controller side for the FLAT data and can use full features of the PIvot Grid.

OR somehow fully support the FLAT data in Pivot Grid (including Configurator, Filtering etc)

Currently the Kendo PivotGrid always starts out with one tuple for each dimension on rows and columns, and you can recursively expand members to get to their children. However, even with a moderately deep hierarchy, this quickly consumes a lot of screen real estate.

It would be useful to have the option to drill-down in addition to expand. I understand that it's not an easy feature to design and implement, mainly due to the merging of cells that occurs when expanding, which is also the reason why the grid must always have one single member on the first level of a dimension on rows/columns; but I'm hoping someone can come up with an idea that would make it easier.

Cheers!

In SSAS world you can often see mega cubes with many measures and dimensions. Currently Kendo pivot grid configurator does not show measure groups and therefore there is no way to filter dimensions and filters that belong to a specific measure group.

Currently measures are displayed as dimensions and there is no visual difference  between them.
I suggest you showing measures as a very first item in the pivot grid configurator. Also please use a  meaningful icon for this item.

Currently there is no way to select database and cube in the analyzer.

http://demos.telerik.com/kendo-ui/pivotgrid/index

Please consider this functionality.