Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Eric
435
MDX Query
posted

I saw a posting that asked:

Is it possible to get the MDX Statement from the Datasource?

And a reply from Infragistics that said:

We have internal property about MDX query. If you think it is useful we can think about the future o

I would be very interested in being able to get the MDX query from the Datasource.  Has there been any more thought about this?

Thanks!

  • 8831
    posted

    Hello,

    With the binaries of the latest service release you can subscribe for XmlaDataSource.InitXmlaMethod event. The event arguments of the event handler contain information about the soap method which we are going to execute against the XMLA service. You can distinguish it by its name or by its type:

     

    private void XmlaDataSource_InitXmlaMethod(object sender, InitXmlaMethodEventArgs e)

    {

        XmlaSoapMethodExecute executeMethod = e.SoapMethod as XmlaSoapMethodExecute;

        if (executeMethod != null)

        {

            string statement = executeMethod.Statement;

        }

    }

     

    Please note that you are able to edit the statement and your statement will be executed but there is no guarantee that the result of the query you’ve built will be processed properly.

     

    Best regards.

    Plamen.