I need to show Top 10 results for a particular column.
Lets say need to display only top 10 customers having maximum internet sales for a product. How can I achieve such functionality using xamPivotGrid. I understand that I might have to change MDX query that is run. (Or is there another way to do this?)
This is being researched to see if a query can be run against the data source. I will update you with my progress as soon as I have any information.
Sam
Thanks.
I spoke with our engineers about this. Apparantly a query such as 'Select Top 5' cannot be run against Pivot Grid records. You would need to query the underlying data source for that.
Thank you for your patience on my response.
Hello,
You may need something like the query described in this post.
Currently we don’t support that functionality. However you can get access to the Execute statement passed to the XMLA service:
With the latest service release we provide 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 sample:
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. Hopefully we can process properly the result returned in response of the modified statement.
Best regards.
Plamen.
Hi Plamen,
I did change the statement and my statement does get executed. While the query runs fine and binds to xamPivotGrid fine, the problem is the state of the PivotGrid expand, collapse for the hierarchical data does not update properly.
Can you tell me how to update that properly?
This has been determined to be a new feature, and I have submitted a feature request on your behalf. Our product team chooses new feature requests for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development you will be notified at that time. Your reference number for this feature request is FR12931.
Thank you for your request,Sam
I would like to offer my support for this feature request FR12931 to allow for access to the MDX query run against the datasource without having to string parse the query. This is a much needed feature to expand the capabilities of the Pivot Grid when displaying OLAP data.
You can look at this samplehttps://es.infragistics.com/samples/silverlight/pivot-grid/#/excel-style-filteringwhere from measures' drop down you can pick up different filters applied for the specified level.
Regards,Plamen
Hi,
You can achieve your goal with setting pivot grid "EnableAdvancedFiltering" property to true. This feature is available only for XMLA DataSource. After this feature is enabled you will see different filtering drop down style. Even filtering is available for measures where you should add the condition for top 10 items. I can reccomend to read this article for excel-style filtering feature: http://es.infragistics.com/help/topic/fdbc4dc2-b0c5-4b2f-89ca-6d26a8f89159
Thanks,
M.Yovchev
Updates on this functionality? I'm aware of other control sets that make this easy to do. Has Infragistics picked up up yet? 2013.1 is already out.
@jmahoney - I created FR13475 created for you and linked FR12931 with it.
@dharmesh_pariawala , @jmahoney:
I have added you both to the list of people to be notified if the feature is chosen for development.
This feature is on the list of Feature Requests to be reviewed for 2012.1. The Infragistics Product Management Team will evaluate all Feature Requests during our next product cycle and set priorities based on customer demand. If your feature is chosen, you will be notified. If you have any questions, please let me know. You can also email DSManager@infragsitics.com for any updates.