--- title: Validating Cognos Audit Data description: How to address inconsistencies within your Cognos audit data records for accurate reporting. image: https://www.envisn.com/hubfs/images/numberss.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 ## [Validating Cognos Audit Data](https://www.envisn.com/envisn-cognos-blog/validating-cognos-audit-data) Posted by [The Envisn Team](https://www.envisn.com/envisn-cognos-blog/author/the-envisn-team) - [Tweet](https://twitter.com/share) *By Paul Hausser, *[*Envisn, Inc.*](https://www.envisn.com/) ![numbers in cognos audit data](https://www.envisn.com/hs-fs/hubfs/images/numberss.jpg?width=284&name=numberss.jpg "numbers in cognos audit data")Our **[recent blogs on Cognos audit data](https://www.envisn.com/envisn-cognos-blog/maximizing-utilization-of-cognos-audit-data)** have focused on getting it to where it can be used easily for anything you want to use it for. Once it’s been normalized this assumes that the data are consistent and capture everything within Cognos. **Unfortunately this isn’t always true. *****So how do we address this?*** ### There are two primary dimensions to the audit data; ***User*** and ***Object*** (or content). One would expect that every audit data record can be tied to both of these dimensions but that isn’t always the case for one reason or another. In the audit data record reconciliation shown below for the month of July for a mid to large Cognos environment, we have a total record count in our fact table of 42,557. This number is a control total. It represents the total number of audit data records in our fact table because each one has an audit data action within Cognos. In many cases the Cognos audit data action record may not have sufficient information to determine ***object type*** or ***user***. UniVisn’s unique process uses advanced algorithms to compensate for this and increase the match rate wherever possible. In our records reconciliation we want to see how many non-matches we have on both object type and user. The ***No Content Ref. Count*** of 50 reflects those records we cannot identify an object type within the content dimension. In the lower section of this table ***No User Ref Count*** of 35 reflects those records where no user match exists. The good news is that both of these numbers combined represent two tenths of one percent (0.2%) of the total number of records 42,557. Said differently, we’re able to reconcile both user and object dimension record count at 99.8% and utilize virtually all of the audit data records for the month of July. These numbers are well within the parameters of accuracy for any purposes of reporting. Plus, we have the record detail for both counts if we wanted to research why user or object type may be some missing data. ![cognos audit data record control reconciliation](https://www.envisn.com/hs-fs/hubfs/images/auditdata-record-control.jpg?width=651&name=auditdata-record-control.jpg "cognos audit data record control reconciliation")Having a system like this that not only maximizes audit record match around the key dimensions but also automatically generates key reconciling numbers for every period processed significantly increases the confidence of users that the audit data numbers are fact based. This is critical for insuring that they will actually be used and trusted in the reporting process. *© [Envisn, Inc.](https://www.envisn.com/) – 2016 - All rights reserved.*     Topics: [Cognos Audit Data](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-data), [Cognos Reporting](https://www.envisn.com/envisn-cognos-blog/topic/cognos-reporting) *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/validating-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)*