Hi all,

I dont think this is possible, but I'll ask anyway.

Is there a way, either through code or SQL, to return a list of what
queries have been executed against a cube?

Programmatically, I dont see the data in
DSO.CubeAnalyzer.OpenQueryLogRecordset.
We have also migrated the OLAP repository to a SQL database. Could the
data be burried in there?

If I can't get the data from MSOLAP 2000, will it be there in MSOLAP
2005?

Thanks,

Chris Brandsma.

You are right. This is not possible. With AS2K, but the time the query gets
to the server it has been converted to a binary parsed request. The best you
can do is to add the Log=filename.txt option to your connectstring. This
tells PTS to log the MDX to an output file. See BOL under the topic PTS
Properties.

In AS2K5, this has changed and all queries are now executed on the server.
And we added support to SQL Profiler so it can profile both SQL events (and
SQL statements) as well as Analysis Services events (and MDX statements).
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<chris.brandsma (AT) gmail (DOT) com> wrote