Skip to Content
0
Jun 08, 2010 at 02:33 AM

Count number of Users in Query output

60 Views

Hi,

I am bringing BW Users Usage report, brings users query access report in BW system. In the report output I am showing all the users information from master data (which shows all users even they don,t have activities in the info cube).

My requirement is to display the total number of users out of which users are accessing the reports. My question is how can I get the total number of users versus query usage number of users.

For example : If I have 100 users in the master data and only 70 users are accessing the Bex Report. I want to show total number of users as 100 and 70 are accessing.

In my query details I have which user executed which report and how many number of times. Based on this how can I count the total number of users.

Thanks

Robert.