Re: Office Web Components and SQL Analysis services, how to trace

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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

"Kam" <Kam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4D933E27-88B3-484B-813F-C4B36AF5AFA5@xxxxxxxxxxxxxxxx
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?


.



Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
    (microsoft.public.access.conversion)