Print Page - Writing a Log file for missing information for a Report

Title: Writing a Log file for missing information for a Report
Post by: jayatu on 11 Mar 2015 01:19:52 AM

Hi All,

Is it possible to create a log file to report missing data for a Cognos report?

Let us say we have 2 tables

employee         appraisal
emp_id name       emp_id Comment
101      E1         101      C1
102      E2         103      C2
103      E3

Here we can see appraisal comments are not available for employee 102. The requirement is while running the appraisal Report any missing data needs to be logged to a file in filesystem.

Is it possible to create such a report in Cognos?

Title: Re: Writing a Log file for missing information for a Report
Post by: bdbits on 11 Mar 2015 10:27:12 AM

You need an outer join between the tables. This can either be done in FM (probably more appropriate there), or you can do two queries and join them in Report Studio.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jayatu on 11 Mar 2015 01:19:52 AM