Get query in RadPivotGrid

2 posts, 0 answers
  1. Antonio
    Antonio avatar
    1 posts
    Member since:
    Nov 2014

    Posted 09 Mar 2015 Link to this post

    Does exist a way to get the query that is executed by a RadPivotGrid using XMLADataProvider?
    I'm referring to the one that's showed in Fiddler debugging web requests like the following:

    <soap:Envelope xmlns:soap="">
      <soap:Header />
        <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
            <Statement>SELECT NON EMPTY CrossJoin({Hierarchize([Promotion].[Promotion Category].AllMembers)},{[Measures].[Internet Order Quantity]}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME,KEY0,KEY1,KEY2,KEY3,KEY4 ON 0 ,NON EMPTY {Hierarchize([Date].[Calendar Year].AllMembers)} DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME,KEY0,KEY1,KEY2,KEY3,KEY4 ON 1 FROM [Adventure Works]</Statement>
              <Catalog>Adventure Works DW 2008R2</Catalog>
  2. Polya
    Polya avatar
    242 posts

    Posted 12 Mar 2015 Link to this post

    Hello Antonio,

    We have a detailed article explaining how to inspect the requests and responses to the Olap cube: Debugging XMLA problems.
    I've also prepared a video where I open our QSF demo: Olap support and using fiddler I capture the query that we send to the Olap cube. Please find the video attached.

    Hopefully this helps.


    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.

Back to Top