Handling the functionality of Pivot Grid from server side

[Mounika]

Hi All,

We have a requirement to show json data as a pivot grid.

We have to fetch with a large amount of data from an SQL DB (about 40.000 to 1.000.000 rows). We are having a service which would return this data as json object.
We need to show this data as a pivot grid restitution in our app, and apparently, that kind of component would suits our needs.

As we have a lot of data : 
- Is this possible at Server-side instead client side?

If this is not possible at server side then what is the max capacity that pivot grid can handle with best performance?

Below is the sample fiddle:

http://dojo.telerik.com/eNAj

Thanks in Advance

[Georgi Krustev]

Hello Mounika,

The built-in cube generation functionality works only on the client-side. The limitation is not strongly defined and depends on many factors. I would suggest you check this help topic for more details. If you would like to use server-side implementation, then you will need to find a 3rd party one.

In general, for such amount of data I would suggest you build the data on the server using either MS SSAS or other server solution. The requirement for the service is to support XMLA protocol as this is what the PivotGrid understands.

Regards,
Georgi Krustev
Telerik