Hello -

When I access the Usage Analysis dialog for a cube (or partition), the
Average Duration always reads 0:00. I know this is not the case....
some of the queries are in fact requiring 8 to 10 minutes to return
data.

Anyone have any ideas on why accurate times are not being recorded?

The query logging is set to 10. Even after a whole week or more of use
all listed queries report 0:00 average duration.

Thanks in advance for any help.
Joel

does the log contains rows?
do you use AS2000 or 2005? where the log is stored?

"Joel Barish" <JoelForBoards (AT) gmail (DOT) com> wrote

Yes the log contains rows. I am using the Usage Analysis dialog and
can see all the queries submitted, but the average duration always is
0:00.

I am using AS2000. Not sure where the log is stored. (accessing the
info through the dialog ui)

thanks for your response and in advance for any ideas you may have...

Jeje wrote: