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)
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