Question:
BW experts,
I would like to find out when a particular query was last run, and
who ran it. Please show me how to do this.
Thanks,
Kevin
Answer:
hi,
search for bw statistics" ...
there are some bc queries, showing the performance of queries, how often it was run and which user called the query ...
greetz,
toadward
Answer:
use ST03N .. use work load starts..
Answer:
I have no idea that w/t installing STATISTICS for cube and query u can do it.
@C h E t A n...
Answer:
BW experts,
I would like to find out when a particular query was last run, and
who ran it. Please show me how to do this.
Thanks,
Kevin
activate Statistics for the InfoCubes on which you would like this data
then activate the BC business content (it contains queries and workbooks as well)
cheers,
El Belgio
Answer:
To be specific, you need to set on statistics for OLAP. The easiest place to manage your statistics is from admin workbench -> tools -> BW statistics for InfoProviders. Choose WHM to keep stats for loading etc and OLAP for Bex activitiy. I find that standard reports (from business content - technical) provide enough information to manage performance of queries and how often they are used.