Intercepting the ChartSpace MDX command

[Corey Alix]

Is it possible to intercept the MDX command generated by the ChartSpace
control?

I am working on a charting application which can run against either a SQL
Server, or an Oracle database. The client acquires data from the server via
webservice calls. A direct connection is an option, but I don't think it is
trivial to expose Oracle as an MDX source
(https://sourceforge.net/projects/mondrian), so would like to find other
options. I'm trying to determine if it is possible to intercept the MDX
command generated by the ChartSpace. If so, I would turn it into a
webservice call, transform the response as necessary, and finally return the
result to the ChartSpace control, so that it may render the chart.

Any insight into how I might intercept the MDX command generated by the
ChartSpace (or PivotTable) control would be appreciated.

 

[Alvin Bruney - ASP.NET MVP]

I believe you will need to use the datasource control of the OWC to get at
these events. The datasource control is used under hood to allow the OWC to
bind to data sources. Unfortunately, there is very little documentation on
this.