I am trying to get some accurate usage stats for our OLAP cubes. I have
amened the properties of the analysis server to log every query rather than 1
in 10.

On querying the above database i see multiple identical rows i.e. the exact
same query has been run upto 30 times in the same second! How can this be!!!

The client tool we are using is ProClarity 5.3

Any Ideas?

I would suggest that you look at the SSAS Operations Guide where we talk
about the query log. It is important that you understand that the query log
has really only ONE use in life -- and that is to be used as data input for
usage-based optimization. You must be extremely careful not to read too much
into what and when values are recorded.
See:
http://www.microsoft.com/technet/pro.../anservog.mspx

As part of your tests you should also log the client-side MDX statements.
See BOL under the topic: "Log File Property"
--
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.

"David Wilson" <David Wilson (AT) discussions (DOT) microsoft.com> wrote

Another useful link is http://www.mosha.com/msolap/articles/querylog.htm

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote