Submitted by Johannes Melkeraaen, Elkjøp Nordic AS and Pål Rune Stenersen, RAV Norge AS
Over time we have made a lot of reports in our Cognos Connection and these are organised in nine top level folders: 1. Sales, 2. Stock, 3. Buying etc …
The typical user navigates in these folders to find their most useful reports, and their respective role eventually define their reports of choice. A pure role based solution to organising the reports can be implemented, but is hard to maintain when new reports are introduced and many users are not easily casted.
Instead, we have made a “My Reports” report with two lists: one for the most frequently run reports and one for the most recently run reports. The report names in the lists are clickable so that the relevant reports can be run from here.
The main advantages of this technique are that users after a short period of report acquaintance don’t have to navigate through the various folders to find their favorite reports.
The following report is built on IBM Cognos BI version 10.1.1 using the Audit package and requires logging set to the appropriate level in order to generate output.