Hi Marianne,

Do we have any update on this. The simple solution that I need is the ability to do Top 10, Top 20 etc. Let me know if there is an easy solution.

Hi,

This is the latest information I received from our development staff.

With the latest service release we provide a XmlaDataSource.InitXmlaMethod event. When you are listening for this event you are able to:

1.       Track all Discover queries passed against XMLA service – it means that in the event handler you have access to properties and restrictions included into the SOAP body when Discover is posted.

2.       Track all Execute queries – you have access to the statement which we generate and execute against XMLA service.

Have a look at this code:

private void XmlaDataSource_InitXmlaMethod(object sender, InitXmlaMethodEventArgs e)

{

    XmlaSoapMethodExecute executeMethod = e.SoapMethod as XmlaSoapMethodExecute;

    if (executeMethod != null)

    {

         string statement = executeMethod.Statement;

    }

}

The statement can be modified and the modified version is the one that we will pass to XMLA service. At this moment we can’t guarantee that we can process properly any result returned in response of the modified statement.

Hi Marianne,

Thanks. But I am aware of that Event. My main problem is getting TOP 10, 20 list. For this I am assuming that I need to change the MDX query dynamically, since I did not see any built in support in Infragistics.

I was trying to see if there is easier way to do this without having to parse the query generated by XmlaDataSource. Since I am not very experienced with MDX, I would rather not do it that way.

Our development staff suggesting that you could use the XmlaDataSource_InitXmlaMethod event.    

As they said, ”the statement can be modified and the modified version is the one that we will pass to XMLA service. At this moment we can’t guarantee that we can process properly any result returned in response of the modified statement.”

It might also be possible to create a custom DataSource object that inherits from XmlaDataSource (eg, XmlaCustomDataSource), and then override the GetXmlaCommand method.  This method should then return something like OlapContainer<XmlaCustomCommand>, where XmlaCustomCommand is defined by you.

Hi Marianne,

I did see the example to override the DataSource. I think for now I am going to stick with changing the query in the InitXmla Event of the DataSource.

Just want to point out here that after looking at the PivotGrid control and the XmlaDataSource Object, I see that there is very limited control over them from the code. I understand that the xamPivotGrid is a new Control provided by Infragistics and I am assuming that since this control is in its infancy, I would love to see more control from customization posibility from the code.

Thank you,

Dharmesh

OK

Unfortunately I can’t provide you with any specific time frame. Feature requests are constantly being reviewed by the product management team as enhancements and then worked into the product design schedule.

Let me know if I can be of further help.

That's great. Do you know approximate time frame by which we will get this feature? I am trying out solution to parse the query and change it. But if your solution is available quickly I might just wait for it.

Thanks a lot.

Dharmesh

Hi,

I'm creating a feature request related to the last suggestion that you made concerning the xamPivotGrid and customizing the xmlaDataSource query.

I'll contact you shortly with more information about your feature request.