The other option is to bind the widget to a SSAS
instance. Basically, the pivotgrid is designed to work with XMLA
standard or its JSON representation. It will perform special XMLA requests, more specifically DISCOVER and EXECUTE, to retrieve only a chunk of the calculated data.
That being said, you will need to align your service to work with that standard
The other option is to write a custom transport
that will communicate with your service and will transform the received data in understandable for the widget format.
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI