Office Web Components and SQL Analysis services, how to trace

[Kam]

I am using OWC - Pivottable for our user to access the SQL Analysis services.
I would like to record the user on how they use, so I can do the analysis
afterward to find out which dimensions, measures is the most populor among
the users or for individual users.

This information will help me to define the default template.

Can I make OWC save the last MDX into a database or all MDX into a database?
How?

 

[Alvin Bruney]

The easiest way i can think of is to use the datasource object and wire some
of the events. The handlers would take the query generated for these events
and write them to the database.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006