We are using an Analysis server cube that our users connect to using excel
pivot tables and data analyzer. Can someone tell me if it is possible to
collect user and field statistics on the use of our cubes? I'm thinking that
I would like to understand which fields are being pulled most frequently and
would also like to understand which users are connecting to our OLAP cubes
most frequently.
If someone knows how to do this could you please post a note.
Thanks in advance.
Josh

If you set the query logging on the server to every 1 query (it defaults
to only logging every 10th query) you will be able to see which levels
of each dimension are being used in queries, but running the Usage Based
Optimisation wizard, but unfortunately I don't know of any way of
printing out this information.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Thanks Darren, I'll give that a shot!

"Darren Gosbell" wrote:

Hello,

If you use AS 2005 (fior now beta) you could trace all mdx statements sent
to server.

Vladimir Chtepa

"tcg_gilbert" <tcggilbert (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:97164ED8-B978-49E9-B32A-4DFB532916FB (AT) microsoft (DOT) com...