---
title: Cognos Data Lineage– Why it Matters – Part 1
description: Data lineage describes the data’s origins, where it moves and what happens to it over time within the Cognos environment.
image: https://www.envisn.com/hubfs/images/data-stream-1.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)

 

# *What if you could use your Cognos audit data for anything you wanted to?*

[![See What the All New UniVisn Can Do for You](https://no-cache.hubspot.com/cta/default/70307/3e64868b-5b60-4894-976e-ba955c88e2b5.png)](https://cta-redirect.hubspot.com/cta/redirect/70307/3e64868b-5b60-4894-976e-ba955c88e2b5)

# Envisn's IBM Cognos Blog

## [Cognos Data Lineage– Why it Matters – Part 1](https://www.envisn.com/envisn-cognos-blog/cognos-data-lineage-why-it-matters-part-1)

Posted by [The Envisn Team](https://www.envisn.com/envisn-cognos-blog/author/the-envisn-team)

- [Tweet](https://twitter.com/share)

*![data lineage stream](https://www.envisn.com/hs-fs/hubfs/images/data-stream-1.jpg?width=300&name=data-stream-1.jpg "data lineage stream")By Paul Hausser, [Envisn, Inc.](https://www.envisn.com/)*

This blog focuses on Part I of the subject of **[Data Lineage](https://www.envisn.com/cognos-data-lineage),** covering what it is and why it’s important. A Part II blog will follow this and focus on creative possibilities for using data lineage in multiple ways once you’ve broken the code.

## What is it?

Simply stated, data lineage describes the data’s origins, where it moves and what happens to it over time. In some environments there are specific requirements for the data lineage and its provenance. This is often the case with financial institutions that have to satisfy regulatory requirements relating to data used for investment purposes.

At one level data lineage may seem rather mundane, but the reality is that without a means to fully document it there is no way to be able to validate it. What appears in a field of a report can be nothing more than an item that’s in a database table such as Order Date or Unit Price. But it could also be something slightly more complex such as a revenue calculation.

Cognos provides a capability within Cognos Connection for looking at data lineage but it’s limited. While you can see it for a report, it shows it for the model items not the report items so it’s not a complete picture. And even if that were done it’s likely you would miss data items used in calculations or calculations embedded in other calculations. There has to be a better way.

*Three things are needed:*

- 1. The ability to capture the data lineage completely for every item that appears in a report or query. If only for documentation purposes, but there are other reasons for doing this as well.
- 2. The ability to see the complete data chain back to and including the database itself.
- 3. A means of persisting this data lineage so it can be referenced if needed.

In **Figure 1** we see the data lineage from a report labeled*** Order Summary.*** There are a number of items in this simple report but we’re only showing two of them here; Total Price and Total Quantity. Total Quantity is simply the sum of all unit quantities. Total Price is Unit Price X Total Quantity X (1 – Discount).

![data lineage levels in cognos report summary](https://www.envisn.com/hs-fs/hubfs/images/data-lineage-fig-1.jpg?width=750&name=data-lineage-fig-1.jpg "data lineage levels in cognos report summary")

*In this example we see the levels of the data lineage:*

- Level 0 represents what is in the report. This could be a model item, another report item or a combination of these.
- Level 1 is the next reference and here we see the same three items as in level 0 except we learn that Tot Price is a calculation. This is at the Package level.
- Level 2 reference represents the FM Model level.
- Level 3 is the database level. This tells us that this calculation is actually at the database level.

### The goal is have all references resolved in the data lineage at the appropriate level of detail.

In the real world there are often more levels shown between the report/query level and the database itself and they can far more complex. Consider something like foreign currency trading for a large New York City bank. **Figure 2** shows one data item from real world example report. It’s called *SwapPoint* and is just one of many items on this report which has the business rules used in trading foreign currencies. Many of the other report data items are even more complex than the algorithms used here.

![complex data lineage levels](https://www.envisn.com/hs-fs/hubfs/images/data-lineage-fig-2.jpg?width=750&name=data-lineage-fig-2.jpg "complex data lineage levels")

The key point is that for an activity that can likely make or lose tens of millions of dollars for the bank, you really need to have good documentation of your data and the rules for using the data. And if something needs to be changed quickly you better know where those rules are being used. Other equally important examples no doubt exist in many other industries.

## The Holy Grail

As mentioned above, persisting or storing this data is also important for multiple reasons many of which will be covered in Part II of this blog. The important thing to know is that the data lineage really is the Holy Grail. *Why?* Because once you’ve captured it correctly, it’s the key to unlocking multiple opportunities that can make your life much easier as a Cognos administrator.

[Data lineage](https://www.envisn.com/cognos-data-lineage) within Cognos should be looked at as a two-step process. The first step is to capture the lineage in a complete and dissembled way. The second part is to store or persist this in a way that it can be referenced for other uses. This is the tricky part but it’s where the big payoff lies. It’s tricky because how it’s dissembled and stored has a lot to do with maximizing its value.

*Read on to see [Part II of the data lineage blog](https://www.envisn.com/envisn-cognos-blog/cognos-data-lineage-infinite-possibilities-part-ii) where we’ll cover some of the things that data lineage enables: [**Cognos Data Lineage – Infinite Possibilities – Part II**](https://www.envisn.com/envisn-cognos-blog/cognos-data-lineage-infinite-possibilities-part-ii)*[![see why envisn customers sat netvisn is essential for cognos bi](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/90ba4bde-4b41-4c1d-a6a5-03dc04736da3.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/90ba4bde-4b41-4c1d-a6a5-03dc04736da3)

*© [Envisn, Inc.](https://www.envisn.com/) – 2017 – All rights reserved.*

 Topics: [Cognos Audit Data](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-data), [cognos data lineage](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-lineage)

*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/cognos-data-lineage-why-it-matters-part-1#)

### 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)](https://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)*