Thank you for replay but Actually I'm facing problem 1. How to fetch the data from OLAP cube basing upon the explicitily generated query as in this above metioned link http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/how-to/access-mdx-query in Kendo Pivot Grid. Is there any kendo function or any solution?
2. Is it possible in Kendo Pivot Grid to filter the records and display it in another grid or pop up by clicking a perticular cell(total) not like shown in http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/how-to/drill-down-with-root-tuple or http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/how-to/filter-dimension links.
Thanks & Regards