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!
Quote from: rodrigorenie on 16 Apr 2020 12:52:49 PM
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.
Quote from: MFGF on 16 Apr 2020 03:37:36 PM
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.