MDX query

[Alessio]

Hi,

I am using the RadPivotGrid to navigate a OLAP cube on Microsoft Analysis Service. The control connects to the cube through Adomd connection string.
I would like to retrieve the MDX query releated to my navigation. Is it possible?

Thanks in advance.

[Pavlina]

Hi Alessio,

RadPivotGrid currently does not support MDX queries. However, you can use the connection as it is shown in the OLAP and KPI Support demo:demos.telerik.com/aspnet-ajax/pivotgrid/examples/olap/defaultcs.aspx

Please excuse us for the inconvenience caused.

Regards,
Pavlina
Telerik

 

 

[Jane]

Hi, 
I am trying to add Top 10 record filter to my radpivotgrid now .
I found out that Telerik not supporting Top/Bottom Filter in Olap connection mode. 
So, I try to use MDX to filter the Top 10 Records, but I don't know how to display my result in the radpivotgrid.
Do you have any idea on this?
TQ 

[Pavlina]

Hello,

Unfortunately, we do not have public property for accessing the MDX Query. I can ensure you I have notified our dev team in order to make decision for implementing the functionality. Note that decisions for future implementations are based on customer demand rate and the control needs.

Regards,
Pavlina
Telerik

 

 

[Jane]

Thanks for the reply. Since MDX can't directly accessing the radpivotgrid, how about I create a subcube with the condition that I want.
Then, I passed that connection's session ID into the connection string of the radpivotgrid? Is it possible for the radpivotgrid to display the Top 10 filter result by this way? 

[Pavlina]

Hi,

You can make additional query in the cube with Top 10 Records, as we have done in our demo for OLAP and KPIs Support:
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/olap/defaultcs.aspx

Then you will be able to display these top 10 records in the filter window of pivotgrid. (refer to the attached screenshot)

Regards,
Pavlina
Telerik

 

 

[Trilochan]

Hi,

1. I want to save the previous state of Pivot Grid  which forms  by drag and drop FIELDS  to COLUMNS, ROWS or MEASURES. How can I able to acess MDX query explicitily to acheive this ?

2. How is it possible to fetch the data based on  permissions (role base) in Telerik Pivot Grid?

Thanks and Regards

Trilochan

[Pavlina]

Hi,

With the current implementation of RadPivotGrid it is not possible to access the generated MDX query. However, a feature request is created and you can give a vote for the item in order to increase its priority:
http://feedback.telerik.com/Project/108/Feedback/Details/146958-improve-radpivotgrid-expose-functionality-for-retrieving-the-generated-mdx-que

The second question is not directly related to the RadPivotGrid control but is rather generic one. However, you can go through the forum thread below where a similar question is disscused:
http://www.telerik.com/forums/how-to-connect-to-cube-using-username-and-password

Regards,
Pavlina
Telerik by Progress

[Trilochan]

Hello Pavlina,

                   Referring to Previous query as you said It's not possible in RadPivotGrid. Is it possible in case of Kendo Pivot Grid(Client  side) in both the above mentioned queries?

Thanks & Regards,

Trilochan

                      

[Pavlina]

Hi,

The example below demonstrates how to access the generated MDX query in a Kendo UI PivotGrid widget.
http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/how-to/access-mdx-query

Regards,
Pavlina
Telerik by Progress

[Trilochan]

Hi Pavlina,
              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
Trilochan