How to know how many users are using a query

[former_member293001]

Hi,

does any of you know how can someone know which user(s) are using a specific query ? Is there a log for a query ?

Cheers,

JS

[Former Member]

The BW Statistics cube BWTC_C02 contains this info. There are standard content queries that access this info (using multi-provider BWTC_C10).

If you are not loading the the Tech Content cubes, you can look at the detail in table RSDDSTAT. You must have the "BW Statistics for InfoProviders" set on for the InfoProviders so that the system gathers this info.