I have Information Analyzer 8.1.0.0 client installed on my machine and have server access also. I have imported tables to IA and done the analysis on it.
I am able to generate some built-in reports available in IA. I need to export this report data from IA to Cognos. Is there any tool available to export report datafrom IA8.1 to Cognos. Or how can I access the analysed data in IA. Please help me....
Thanks in Advance.
Information Analyzer 8.1.0.0 How to Export report data
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You are in trouble trying to get this working in version 8.1 because you do not have the API layer of Information Analyzer. Version 8.5 or 8.7 will be much easier. With the Information Analyzer API layer you can get to profiling results and data quality rule results as API calls. You can either mash that up in Cognos or create a set of DataStage jobs to put Information Analyzer results into a data mart for reporting. IA 8.5 and 8.7 also have better export options. You might be able to cobble something together in Metadata Workbench where you create a query to extract profiling results and manually save that to an Excel spreadsheet for use in Cognos.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I should also add that the reason this is tricky - the reason you cannot just point Cognos straight at the profiling tables - is that XMETA and IADB where profiling results get stored are both cryptic data stores that Cognos cannot model and use. You need either an export or access to the API layer to make sense of profiling data.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn