David, the usage is not stored in the repository -- it's in a separate .mdb
named msmdqlog.mdb located in bin directory. It contains just one table
(last time I looked). You will need to do some deciphering. It logs which
levels of which dims were queries, not the actual query.
tom @ the domain below
www.tomchester.net
"david wilson" <david.wilson (AT) rmc (DOT) co.uk> wrote
Quote:
Are there any nice utilities out there for reporting on
usage stats. The one provided in the AS mmc is a little
limited to say the least.
I have logging set to every query for a short while &
would like to really analyze usage.
Our repository is migrated to SQL - can i get at the table
where these stats are stored? |