I have a requiremnet to analyse Query Usuage in our nvironment. I basically need below infomation
a. How many times a query was accessed
b. Number user Attempts per day.
c. Query runtime
d. Query used by which user
e. Query last accessed on date
I know BW statistics cube can be used.
But I would like to know what Cubes and what reporrts needs to used.