[Solved] Get query in RadPivotGrid

[Antonio]

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>


[Polya]

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