Writing a Log file for missing information for a Report

[jayatu]

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?

[bdbits]

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.