July 16, 2003 at 12:05 pm
Short of a screen capture, is there any way to get at the data behind the Usage Analysis Wizard's reports?
I'm interested in capturing the data to track usage of the cube etc. Does SQL Profiler have the ability if the repository has been migrated to SQL Server?
Thank you!
--dao
July 18, 2003 at 2:02 pm
The data of the Usage Analysis is saved in the access database: msmdqlog.mdb under then bin directory of the AS.
July 21, 2003 at 9:23 am
What if one has migrated the repository to SQL Server 2000?
-dao
July 23, 2003 at 3:17 pm
Found out what I need. Used the 'OpenQueryLogRecordset' method off of the DSO com object.
There is sample code for using the method in the BOL.
July 23, 2003 at 3:23 pm
quote:
What if one has migrated the repository to SQL Server 2000?-dao
FYI: The repository is different from the query log. If you migrate the repository to SQL, AS still stores the queries in Access.
July 25, 2003 at 9:01 am
Yeah I noticed that the query log was still in Access.
I am able to get the chunk of software I wrote in VS dot-net to read the log, but now i'm finding that the log is apparently getting reset under certain criteria. We have a SQL Agent job running DTS scripts to process the cube's data nightly. If i process the cube outside of this process, the log does not get reset, but i'm wondering if the DTS script is doing something to reset it.
Gotta love the documentation on the query log 😉 (saracasm...)
--dao
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply