Skip to Content
avatar image
Former Member

Audit Report: Named and Concurrent User Count

Hi

I am creating a Audit report (BI 4.0) using Audit universe downloaded from SCN. However I am not sure how to show Total no of logons by user type (Names/Concurrent) for a given day.

Can i use default measure (Number of Logons- Total) from Audit universe and filter it by "Event Status="Concurrent User Logon Succeeded" Or do we need to create a separate measure to count session Id's.

Does "Event Detail Value" represents cumulative user count and we can safely use No of Logons=max(Event Detail value)

However if you look ate below report it has same session by Event Detail Value is increasing. Hows this possible.

Audit.JPG (95.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 17, 2013 at 03:40 PM

    You need to count the unique number of Session IDs.

    The detail "Concurrent user count" represents the number of sessions that where currently active at the time that logon/logoff event occurred AND only for sessions that are comprised of users with a 'connection type' set as 'concurrent' (rather than 'named user').

    It would make sense to do a MAX of the 'Concurrent user count' to see what the peak number of sessions where, for sessions that are comprised of users with a 'connection type' set as 'concurrent' (rather than 'named user').

    Makes sense?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi James,

      The 'Concurrent User Count' will have a relationship with the 'sessions' tab you see in the CMC. However the 'sessions' tab in the CMC will show the number of sessions created by user IDs that are both 'Named User' and 'Concurrent User'. (A user ID can and must be only be one of these).

      The 'Concurrent User Count' in the Audit DB is the number of sessions, at the time that event occurred, that where caused by user IDs that are defined as 'Concurrent User'. If all your users where defined as 'Concurrent User', then the Concurrent User Count' in the Audit DB will have a direct relationship with what you see in the CMC Sessions.

      Here's a related link, not sure if its helpful for you, but maybe others:

      Monitoring Concurrent Sessions in SAP BI Platform 4.0 and BusinessObjects Enterprise XI3.1

  • avatar image
    Former Member
    Jan 23, 2015 at 07:29 AM

    As a little remark:

    In order that the "Max" function is working for "Event Detail value" correctly, you need to convert it to a number e.g.

    =Max(ToNumber([Event Detail Value]))

    Add comment
    10|10000 characters needed characters exceeded