Skip to Content
0
Former Member
Apr 18, 2008 at 03:22 PM

Request mechanism to retrieve usage and performance statistics in BPC?

14 Views

Hi BPC Gurus,

We have just completed rolling out BPC 5.1 and were interested in monitoring the health & user adoption (e.g. number of users logged in, how many times they logged in, what kind of reports they ran, how long the EVDRE query for those reports took etc).

I have scoured through all the available tables for the Appset & the audit database at the SQLServer level and could not find any table that holds information around this. The only information I found was around the logged in statistics for Administrators via table tblLoggedIn and the statistics of who keyed in data using Input templates via the audit tables.

Is there some roundabout way to get this information at least something to the tune of who logged in and when?

On the BW side, there is a rich set of information through the use of pre-delivered Statistics cube that provides myriad details which can be used to monitor the health and usage of the system. Are there plans to include this kind of statistical information in BPC 7.0?

Your help and guidance would be greatly appreciated.

Thanks,

Abhay Shanbhag