Monday, January 14, 2013

How to find impacted reports and data lineage

Context
It is imperative to know the report impact and data lineage, when changing data mart. Cognos provides both tools, or framework manager and data lineage to rescue, which is very useful for all users, including business analyst, architect, developers and project manager.

Impacted reports

It is very useful to figure out what query subjects are used in what report. Cognos FM can not only provide you at query subject level, but also at individual column level. For example, you want to find what reports use Revenue.






If you want to want to get the meta data into excel, or more formatted fashion, you can save it into xml file, then create a xslt file as parser like below

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
 <html>
 <body>
 <table border="1">
   <tr bgcolor="#9acd32">
     <th>Path</th>
     <th>Report</th>
     <th>Query</th>
     <th>QueryItem</th>
   </tr>
   <xsl:for-each select="ImpactRequest/Results/CMObject/Item">
   <tr>
     <td><xsl:value-of select="../@Path"/></td>
     <td><xsl:value-of select="../@Name"/></td>
     <td><xsl:value-of select="@QueryName"/></td>
     <td><xsl:value-of select="."/></td>
   </tr>
   </xsl:for-each>
 </table>
 </body>
 </html>
</xsl:template>
</xsl:stylesheet>

Then add two lines below into saved xml file

<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="parser.xslt"?>

Finally, open xml file and get your spreadsheet.

Data lineage


When developing report, we often ask “how did we get that number”. The quickest way to get the answer is to use Data Lineage, which provides the answer to this question: firstly in business terms, then also as a technical expression that identifies specific sources, calculations and rules.  There are two ways to get detail data lineage

From package



From report (or other studios)


2 comments:

  1. Data Quality - Business sold directly to Customers, or through dedicated Channel Partners, will be brought into the Adaptive Partner Program network for delivery and support.  A key qualifier will therefore be the availability of IT delivery skills and first line support skills in the Partner organization.  The partner will be trained by Adaptive, both to sell and to deliver the product (including customization).

    ReplyDelete
  2. Adaptive continues to be a thought leader in acquiring and packaging technologies that meet key needs in the Data Lineage, governance, and risk analysis markets.

    ReplyDelete