--- title: Maximizing Utilization of Cognos Audit Data description: Using available Cognos audit data and aligning it along key data dimensions coupled with reference data from the actual Cognos environment. image: https://www.envisn.com/hubfs/images/audit-data-dimensions.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) ![cognos security management in netvisn](https://www.envisn.com/hs-fs/file-897555366-png/images/icon-secur-manag.png?width=143&name=icon-secur-manag.png "cognos security management in netvisn") # Cognos Security ### *as you've never seen it* # Envisn's IBM Cognos Blog ## [Maximizing Utilization of Cognos Audit Data](https://www.envisn.com/envisn-cognos-blog/maximizing-utilization-of-cognos-audit-data) Posted by [The Envisn Team](https://www.envisn.com/envisn-cognos-blog/author/the-envisn-team) - [Tweet](https://twitter.com/share) *![audit data dimensions](https://www.envisn.com/hs-fs/hubfs/images/audit-data-dimensions.jpg?width=175&name=audit-data-dimensions.jpg "audit data dimensions")By Rick Ryan, *[*Envisn, Inc.*](https://www.envisn.com/) In our previous blog article, *[Creating a Framework Manager (FM) Model for Cognos Audit Data](https://www.envisn.com/envisn-cognos-blog/creating-a-framework-manager-fm-model-for-cognos-audit-data)*, we talked about work that we’ve recently done to create dynamically modeled relational data in the form of a FM Model. Our intent was to capture all available audit data and align it along key data dimensions and couple it with reference data from the actual Cognos environment. Doing this required at least a couple iterations. As we started to actually use the data to create the vision we wanted of **[UniVisn](https://www.envisn.com/univisn-cognos-performance-management)** being reflective of a real world Cognos environment we needed to tweak some things like relative time periods, object type dimensions and status and sources. *The updated measures and dimension map for these can be seen in figures 1 and 2.* *![congos measures and Dimensions](https://www.envisn.com/hs-fs/hubfs/images/Univisn-Dimensions-fig1-2.jpg?width=725&name=Univisn-Dimensions-fig1-2.jpg "congos measures and Dimensions")* The next big step was to decide how to best utilize all of these data capabilities for a real world environment. We call this the presentation layer. And for this we decided to use Cognos Workspaces and create a series of dashboards covering some key areas. These included: - *User access stats * - *Run time stats * - *Activity stats * - *Dispatcher stats * - *Error stats * - *Workspace stats * - *Object stats* Examples of these can be seen in the figures below. Each of these Workspaces consists of a number of charts, graphs or reports that ideally reflect the real operational needs of an audit data dashboard in a Cognos environment. But if not, they can easily be changed, swapped out or modified for others that better fit specific needs around audit data. The great thing about Cognos Workspaces is that they’re flexible enough for you to get exactly what you need as long as you have the data needed to drive them. And they’re easy to work with. Figure 3 shows user access statistics including the percentage of active users over the past three months along with a list report of users with no activity for a threshold number of days. It also shows the top users by package in the environment. ![cognos data user access stats](https://www.envisn.com/hs-fs/hubfs/images/Univisn-Dimensions-fig3.jpg?width=725&name=Univisn-Dimensions-fig3.jpg "cognos data user access stats") Figure 4 shows a list report and a number of charts displaying report run times along a number dimensions. These are examples showing the level of granularity one can get on run times when you have a broad set of dimensions with which to use the audit data. ![cognos data run time stats](https://www.envisn.com/hs-fs/hubfs/images/Univisn-Dimensions-fig4.jpg?width=725&name=Univisn-Dimensions-fig4.jpg "cognos data run time stats") Figure 5 focuses on execution errors. There are a number of ways that these can be viewed and this example shows some common ones. Other examples might include looking at these by error detail type, time of day and object type. ![cognos data execution error stats](https://www.envisn.com/hs-fs/hubfs/images/Univisn-Dimensions-fig5.jpg?width=725&name=Univisn-Dimensions-fig5.jpg "cognos data execution error stats") Using Cognos Workspace is a perfect match for the Cognos audit data. It is highly flexible in terms of how the data can be utilized for maximum impact; charts, graphs and reports can be used together to create effective dashboards. With good user feedback you will be able to come up with the right mix of presentation types to make the dashboards that work best for your environment. And it’s yet another example of our ongoing effort in using Cognos to report on itself. *In our [next blog](https://www.envisn.com/envisn-cognos-blog/validating-cognos-audit-data) we will cover how users can [validate the accuracy of the numbers coming out of their Cognos audit data.](https://www.envisn.com/envisn-cognos-blog/validating-cognos-audit-data) This is important because if users don’t trust the numbers they won’t be used.*   *[![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, Inc.](https://www.envisn.com/) – 2016 - All rights reserved.* Topics: [Cognos Tools](https://www.envisn.com/envisn-cognos-blog/topic/cognos-tools), [Cognos Audit Data](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-data), [cognos workspace](https://www.envisn.com/envisn-cognos-blog/topic/cognos-workspace) *Your feedback is very important to us - we’d love to hear your comments!* ### Subscribe to Envisn's IBM Cognos Blog [![learn more about univisn](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/341d1bbc-04de-486f-b11d-2e9ac2462419.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/341d1bbc-04de-486f-b11d-2e9ac2462419) ### 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/maximizing-utilization-of-cognos-audit-data#) ### Posts by Popularity [![free download expert guide to cognos audit data](https://no-cache.hubspot.com/cta/default/70307/6933ba0f-4664-4d5d-9413-edf64d7b2644.png)](http://cta-redirect.hubspot.com/cta/redirect/70307/6933ba0f-4664-4d5d-9413-edf64d7b2644) ### [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)*