Thanks.

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.

@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.

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.