How to get User Selection in Pivot Table

[bajirao]

Hello
I know that OWC issues a command to the server whenever user drag and drop a dimension from the list . How to trap that quesry
My intention is to just get the user selected measures and dimensions/levels. So that I can use it later to query the OLAP

Regards
Bajira

 

[Mark G]

Try using the QueryComplete() or DataChange() events for the Pivot Table
object.

Hello,
I know that OWC issues a command to the server whenever user drag and drop

a dimension from the list . How to trap that quesry.

My intention is to just get the user selected measures and

dimensions/levels. So that I can use it later to query the OLAP.