MDX query

11 posts, 0 answers
  1. Alessio
    Alessio avatar
    2 posts
    Member since:
    May 2012

    Posted 07 Apr 2014 Link to this post

    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.
  2. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 10 Apr 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Jane
    Jane avatar
    2 posts
    Member since:
    Aug 2014

    Posted 13 Aug 2014 in reply to Pavlina Link to this post

    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 
  5. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 14 Aug 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  6. Jane
    Jane avatar
    2 posts
    Member since:
    Aug 2014

    Posted 17 Aug 2014 in reply to Pavlina Link to this post

    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? 
  7. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 21 Aug 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  8. Trilochan
    Trilochan avatar
    3 posts
    Member since:
    Aug 2016

    Posted 19 Sep Link to this post

    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

  9. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 22 Sep Link to this post

    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
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  10. Trilochan
    Trilochan avatar
    3 posts
    Member since:
    Aug 2016

    Posted 22 Sep in reply to Pavlina Link to this post

    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

                          

  11. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 22 Sep Link to this post

    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
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  12. Trilochan
    Trilochan avatar
    3 posts
    Member since:
    Aug 2016

    Posted 27 Sep in reply to Pavlina Link to this post

    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

Back to Top
UI for ASP.NET Ajax is Ready for VS 2017