--- title: Using Cognos Audit Data Creatively description: Cognos audit data available from out-of-the-box IBM Cognos is limited, so we'll focus on going beyond the basics and using it in some creative ways. image: https://www.envisn.com/hs-fs/file-912082464-jpg/images/data-icons.jpg --- [![envisn](https://www.envisn.com/hs-fs/file-15282154-gif/images/logo.gif?width=120&name=logo.gif "envisn")](https://www.envisn.com) [![Request a Demo](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/973f9256-ef61-4ab8-ab2d-a004a90a18be.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/973f9256-ef61-4ab8-ab2d-a004a90a18be) [![learn more about univisn](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/dba5548b-93d7-4f6d-88ec-c29e28afd21b.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/dba5548b-93d7-4f6d-88ec-c29e28afd21b) # Envisn's IBM Cognos Blog ## [Using Cognos Audit Data Creatively](https://www.envisn.com/envisn-cognos-blog/bid/103689/How-to-Use-Cognos-Audit-Data-Creatively) Posted by [Rick Ryan](https://www.envisn.com/envisn-cognos-blog/author/rick-ryan) - [Tweet](https://twitter.com/share) *By Paul Hausser, [Envisn, Inc.](https://www.envisn.com/)* ![audit data icon stream](https://www.envisn.com/hs-fs/file-912082464-jpg/images/data-icons.jpg?width=199&height=199&name=data-icons.jpg)The biggest challenge faced by Cognos administrators in any Cognos BI environment is having the tools and information needed to manage it. A key part of this needed information is a complete picture of usage and overall utilization. Creating this can be a challenge but once it’s done the payoff can be huge. In this blog we will focus on going beyond the basics and using the Cognos audit data in some creative ways. ### Going Beyond Basics ***Can you use the audit data available from the standard, out-of-the-box offering that IBM Cognos provides?*** Yes, but you’ll quickly find there are some limitations with what you get here. Our previous blog on [Cognos Audit Extensions](https://www.envisn.com/envisn-cognos-blog/bid/102863/Using-IBM-Cognos-10-Audit-Extensions) noted that the sample reports provided with this can be helpful up to a point but have limited dimensionality and measures. Moving beyond this requires some work unless you decide to purchase a tool that does this for you. The key thing to keep in mind here is that the value of going beyond the basics of what’s available is that the benefits are cumulative. The more you are able to do with the audit data the more you’ll be able to extend this into new areas of use and build upon what you have created. Adding dimensionality and measures can greatly enhance the basic audit data to be able to identify problems or opportunities. One or more organizational dimensions can add a lot of value to analyzing what content is being used, with what frequency and by whom. More granular measures on usage such as sessions, activity types and content will make it easier to add value and precision to your audit data for usage analysis and reporting. ### Form Factor ***Standard reports or OLAP? –*** In many Cognos environments the audit data is used in multiple reports with different dimensions while others use OLAP cubes. Reports are best for standard metrics on things like utilization of content, frequency of usage, Pareto analyses, etc. OLAP cubes have an advantage when exploring and analyzing the data because of the ease with which this can be done on the fly. Drill-through reports are the example where both are used together. Thus, most environments will usually have a mix of offering audit data using mulitple formats. The decision should be made on what makes it easiest to consume the information. ### **[![Figure 1 - Average User Session Length](https://www.envisn.com/hs-fs/file-914737851-png/images/figure_1_-_average_user_session_length.png?width=200&height=219&name=figure_1_-_average_user_session_length.png)](https://www.envisn.com/getting-creative-cognos-audit-data/)**Getting Creative Cognos Audit Data Some examples of using Cognos audit data creatively include the following items: 1. **Average User Session Length –** *(Figure 1 - click image to view full size)* This example shows average session length by users from high to low for a given time period. 2. **Report Run Count by Dispatcher and Run Type –** This is useful for looking at the load by dispatcher and run type (interactive or batch) for a given time period. 3. **Object Type Count by Package –** Makes it easy to see which FM packages are actually being used and weed out those that have no usage. 4. **[![Figure 2 - Reports Average Run Times](https://www.envisn.com/hs-fs/file-919301325-png/images/figure_2_-_reports_average_run_times.png?width=200&height=181&name=figure_2_-_reports_average_run_times.png)](https://www.envisn.com/getting-creative-cognos-audit-data/)**Report Average Run Times – *(Figure 2 - **click image to view full size*) Identifies reports with consistently long run times that may indicate problems. Can also drill down on weeks/days/hours. 5. **New Content Adoption Rates by Organization and User –** Measures subsequent usage of new content developed in a given period. Useful to see if new content is actually being used and how quickly it’s being adopted. 6. **Test Validation –** Shows run counts for reports in Test or UA environment to validate that testing is actually being done. 7. **[![Figure 3 - Reports Run But Never Viewed](https://www.envisn.com/hs-fs/file-917821942-png/images/figure_3_-_reports_run_but_never_viewed.png?width=198&height=69&name=figure_3_-_reports_run_but_never_viewed.png)](https://www.envisn.com/getting-creative-cognos-audit-data/)Reports Scheduled & Run but Never Viewed –** *(Figure 3 - **click image to view full size*) This can be a problem in any environment but especially in large ones where users may schedule and run reports but seldom, if ever, look at them. Getting control of this can free up lots of platform resources. 8. **[![Figure 4 - Run Count by Hours ](https://www.envisn.com/hs-fs/file-919301320-png/images/figure_4_-_run_count_by_hours__days.png?width=200&height=216&name=figure_4_-_run_count_by_hours__days.png)](https://www.envisn.com/getting-creative-cognos-audit-data/)Run Count by Hours/Days –** *(Figure 4 - **click image to view full size*) Shows run activity by week broken down into hours and days. Helpful for identifying peak activity periods. 9. **Users With No Activity –** This can be useful in identifying user licenses that can be redeployed. 10. **Reports Ranked by Success/Failure Rate –** Identifies reports that consistently have problems. 11. **Top Active Reports –** Useful for identifying most popular reports by organization, package, user, etc. Once you’ve created the appropriate dimensions and measures to use with the Cognos audit data the creative opportunities are limited only by your imagination and real needs. Focus on those that represent real opportunities to expand user adoption and remove problems that get in the way of users.[![free download expert guide to cognos audit data](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/8d7bc58a-4b43-4560-8d8e-74a724888296.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/8d7bc58a-4b43-4560-8d8e-74a724888296) © 2014 Envisn, Inc. – All rights reserved. [*Advanced Tips for Cognos Audit Data*](https://www.envisn.com/envisn-cognos-blog/bid/103289/Advanced-Tips-for-Cognos-Audit-Data) Topics: [Cognos Audit Data](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-data) *Your feedback is very important to us - we’d love to hear your comments!* ### Subscribe to Envisn's IBM Cognos Blog [![Your Content Store contains thousands of objects with hundreds of properties. netvisn gives you control of all of it learn more](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/c76703b2-30ab-4086-9bc3-f2c890de7c5f.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/c76703b2-30ab-4086-9bc3-f2c890de7c5f) ### Posts by Category - [Cognos Content Store (22)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-content-store) - [Cognos BI Best Practices (21)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-bi-best-practices) - [Cognos Analytics (19)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-analytics) - [Cognos BI administration (19)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-bi-administration) - [Cognos Security (18)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-security) - [Cognos Tools (14)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-tools) - [Cognos Audit Data (11)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-data) - [Cognos Reporting (9)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-reporting) - [Cognos Auditing (8)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-auditing) - [Cognos 10 (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-10) - [Cognos Framework Manager (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-framework-manager) - [Cognos Metadata (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-metadata) - [BI Trends (6)](https://www.envisn.com/envisn-cognos-blog/topic/bi-trends) - [IBM Information on Demand (6)](https://www.envisn.com/envisn-cognos-blog/topic/ibm-information-on-demand) - [Cognos Audit Log (5)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-log) - [cognos impact analysis (4)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-impact-analysis) - [Big Data (3)](https://www.envisn.com/envisn-cognos-blog/topic/big-data) - [Cognos Data Sources (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-sources) - [Cognos Documentation (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-documentation) - [Cognos Scheduling (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-scheduling) - [Product Information (3)](https://www.envisn.com/envisn-cognos-blog/topic/product-information) - [cognos data lineage (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-lineage) - [Archiving Cognos Content (2)](https://www.envisn.com/envisn-cognos-blog/topic/archiving-cognos-content) - [Cognos FM Model (2)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-fm-model) - [Cognos migration (2)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-migration) - [Announcements (1)](https://www.envisn.com/envisn-cognos-blog/topic/announcements) - [Cognos Change Management (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-change-management) - [Cognos Data Provenance (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-provenance) - [Cognos Hotfiles (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-hotfiles) - [Cognos Powerplay (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-powerplay) - [Cognos Triggers (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-triggers) - [Consolidating Cognos Environments (1)](https://www.envisn.com/envisn-cognos-blog/topic/consolidating-cognos-environments) - [Impromptu (1)](https://www.envisn.com/envisn-cognos-blog/topic/impromptu) - [Merging Content Stores (1)](https://www.envisn.com/envisn-cognos-blog/topic/merging-content-stores) - [Remote Cognos Management (1)](https://www.envisn.com/envisn-cognos-blog/topic/remote-cognos-management) - [cognos deployments (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-deployments) - [cognos fm model documentation (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-fm-model-documentation) - [cognos workspace (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-workspace) - [netvisn (1)](https://www.envisn.com/envisn-cognos-blog/topic/netvisn) [see all](https://www.envisn.com/envisn-cognos-blog/bid/103689/How-to-Use-Cognos-Audit-Data-Creatively#) ### Posts by Popularity [![cognos custom queries free download](https://no-cache.hubspot.com/cta/default/70307/81f539ec-bb7d-4a54-a992-18729e2cabda.png)](http://cta-redirect.hubspot.com/cta/redirect/70307/81f539ec-bb7d-4a54-a992-18729e2cabda) ### [Cognos Tools from Envisn](https://www.envisn.com/envisn-products) [NetVisn](https://www.envisn.com/netvisn) [AutoVisn](https://www.envisn.com/autovisn-cogos-scheduler) [UniVisn](https://www.envisn.com/univisn-cognos-performance-management) [DocuVisn](https://www.envisn.com/docuvisn-cognos-documentation) ### [Cognos Resources](https://www.envisn.com/resources) [Envisn’s IBM Cognos Blog](https://www.envisn.com/envisn-cognos-blog) [Custom Query Library](https://www.envisn.com/custom-query-library) [Tutorial Videos](https://www.envisn.com/cognos-demo-videos) [Mastering Cognos Security](https://www.envisn.com/mastering-ibm-cognos-security) [Content Store Survival Guide](https://www.envisn.com/content-store-survival-guide) [Expert Guide to Cognos Audit Data](https://www.envisn.com/cognos-audit-data-expert-guide) ### [Contact Envisn](https://www.envisn.com/contact) [Request a Demo](https://www.envisn.com/request-a-demo) [Support](https://www.envisn.com/support) 512-991-3999 [info@envisn.com](mailto:info@envisn.com) ### Latest Cognos Posts | [![youtube](https://www.envisn.com/hs-fs/hubfs/youtube.png?width=30&name=youtube.png)](https://www.youtube.com/user/envisn) | [![linkedin](https://www.envisn.com/hs-fs/hubfs/linkedin.png?width=30&name=linkedin.png)](https://www.linkedin.com/company/envisn-inc./) | [![twitter](https://www.envisn.com/hs-fs/hubfs/twitter.png?width=30&name=twitter.png)](https://twitter.com/Envisn) | [![facebook](https://www.envisn.com/hs-fs/hubfs/facebook.png?width=30&name=facebook.png)](https://www.facebook.com/envisn/) | | --- | --- | --- | --- | [![Real Time Analytics](https://static.getclicky.com/media/links/badge.gif)](http://clicky.com/101126274) ![Clicky](https://in.getclicky.com/101126274ns.gif) 3000 Polar Lane, Suite 901, Cedar Park, TX 78613 USA *Serving North America, Europe, and the UK with plans to expand to other areas in the near future. **[Privacy, Copyright & Liability](https://www.envisn.com/privacy-copyright-liability)*