Sorry. It cannot be done. There no logging facility server-side.
You can track queries from the client using "logfile=" on the connect
string.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rajesh" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi All,
I want to be able to store somewhere all the mdx queries sent to the
analysis server using any client (say proclarity).
I understand we can set on the server to log every nth query sent to
server. But I was not able to locate that log file anywhere. I am able to
|
locate processing log file but not the query log file.
Quote:
Any help on this is highly appreciated. |