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

    Hello,
    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="http://schemas.xmlsoap.org/soap/envelope/">
      <soap:Header />
      <soap:Body>
        <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
          <Command>
            <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>
          </Command>
          <Properties>
            <PropertyList>
              <Catalog>Adventure Works DW 2008R2</Catalog>
              <Format>Multidimensional</Format>
              <Content>Data</Content>
            </PropertyList>
          </Properties>
        </Execute>
      </soap:Body>
    </soap:Envelope>
  2. Polya
    Admin
    Polya avatar
    199 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.

    Regards,
    Polya
    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. DevCraft banner
Back to Top