I'm looking for an event that fires before the SSAS database gets queried. I want to be able to modify the Columns/Rows/Measures/Filter of the datasource programatically before every call to the database.
Example:User drags a measure into the grid to add it. Then the grid gets updated with the new data. I want to change the Columns/Rows/Measures/Filter that get sent before the grid updates with the new data.
I looked at pivotGrid.DataSource.PropertyChanged, but it fires a LOT on each action the user does. This would probably work, but doesn't seem to be what I'm looking for.
I looked at pivotGrid.DataContextChanged but it didn't fire when I was expecting.
Thanks for any help on this.
-BEP
Hi BEP,
Are you using an XmlaDataSource? If so then you can try using the InitXmlaMethod. This method is fired right before any queries are sent to the database. You can actually use this event to look at the SQL statement being sent as well. http://help.infragistics.com/NetAdvantage/Silverlight/2013.1/CLR4.0/?page=InfragisticsSL5.Olap.Xmla.v13.1~Infragistics.Olap.Xmla.XmlaDataSource~InitXmlaMethod_EV.html
Yes, we're using an XmlaDataSource and what you suggested was exactly what I needed. I handled this event, dug down in the sender object, and found what I needed.
Thank you for your holp.