Hello,
I am looking to override XmlaCommand to change the IQuery that runs in special case. I do not want to override other classes such as XmlaDataProvider, XmlaConnection; How can I make the XmlaDataSource to use the command class that I override?
I appreaciate your help.
Hi,
I'm looking into your question and I'll get back to you shortly.
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.
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.
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
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.
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.
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.
OK