How to build a Dashboard that counts concurrent users? Or how to format my data?

[rodrigorenie]

Hello everyone, I need help on how to build a Dashboard or a Report in Cognos Analytics 11.0. I have a table with the following information:

SessionID	UserID	Login	Logout
001	renie	2020-04-16 12:00:00	2020-04-16 14:00:00
002	rodrigo	2020-04-16 12:15:00	2020-04-16 12:30:00
003	daia	2020-04-16 12:20:00	2020-04-16 13:40:00
004	anakin	2020-04-16 13:00:00	2020-04-16 13:30:00
005	leia	2020-04-16 13:20:00	2020-04-16 13:50:00

Basically, a table with Login and Logout date for every user.

What I need to do is count how many users were logged in at the same time overtime, like, every hour and show it in a dashboard or report. A dashboard would be very nice to select, for example, the month that I want to analyze.

I simply have no ideia where to start.

With Cognos aside, I figure that I can create a temporary table with a column that has all possible dates from the lowest logindate to the highest logout date in 1 hour increments, and than left join this table with my original table, but I wonder if Cognos has any solution for this situation.

Thank you for your time!

[MFGF]

Hello everyone, I need help on how to build a Dashboard or a Report in Cognos Analytics 11.0. I have a table with the following information:

SessionID	UserID	Login	Logout
001	renie	2020-04-16 12:00:00	2020-04-16 14:00:00
002	rodrigo	2020-04-16 12:15:00	2020-04-16 12:30:00
003	daia	2020-04-16 12:20:00	2020-04-16 13:40:00
004	anakin	2020-04-16 13:00:00	2020-04-16 13:30:00
005	leia	2020-04-16 13:20:00	2020-04-16 13:50:00

Basically, a table with Login and Logout date for every user.

What I need to do is count how many users were logged in at the same time overtime, like, every hour and show it in a dashboard or report. A dashboard would be very nice to select, for example, the month that I want to analyze.

I simply have no ideia where to start.

With Cognos aside, I figure that I can create a temporary table with a column that has all possible dates from the lowest logindate to the highest logout date in 1 hour increments, and than left join this table with my original table, but I wonder if Cognos has any solution for this situation.

Thank you for your time!

Hi,

A good place to start would be to look at the Auditing capabilities in Cognos Analytics. There is an admin step required to set up an audit database and have the system log information to it, but once that is done, IBM helpfully provides a package and some sample reports based on this (and of course you can create your own custom reports/dashboards too).

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ig_smples.doc/c_sampleauditreports.html

Cheers!

MF.

[rodrigorenie]

Hi,

A good place to start would be to look at the Auditing capabilities in Cognos Analytics. There is an admin step required to set up an audit database and have the system log information to it, but once that is done, IBM helpfully provides a package and some sample reports based on this (and of course you can create your own custom reports/dashboards too).

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ig_smples.doc/c_sampleauditreports.html

Cheers!

MF.

This table is not Login/Logout information from Cognos itself, is a table another application in my company generates, and I need to count simultaneous access in that application.