Home > Solutions > CoMetReporter

It is a metadata reporting layer on top of Cognos 8 BI.

• Reads Framework Manager model data.
• Reads Cognos Connection metadata.
• Loads metadata into to a relational database.
• Provides a semantic layer on top of this metadata.

CometReporter is intended for:

• the Cognos BI 8 system administrator;
• the business analyst;
• the Framework Manager modeler;
• and the report author.

When working in Cognos Connection in an environment that is intensively used, we are often faced with questions regarding the metadata of reports, folders, views, and all other objects within Cognos Connection. Questions we ask ourselves every day but for which Cognos does not offer an easy to use and straight forward way of answering it. We need to browse through the portal open different screens and view the properties to find answers. Using CoMetReporter you can easily browse through the metadata of Cognos Connection and all its objects using for instance Query Studio!

Examples of the things we are looking for in Cognos Connection:

• Which reports/jobs are scheduled when?
• Which output formats are being used?
• Which reports are bursted?
• Which reports are being mailed? To whom?
• Where do reportviews reside for which reports?
• How do packages link to reports?
• Which reports fail when being executed?
• You want to keep track of report execution time beyond the track of Cognos?
• ...

A business analyst or Cognos report author can have questions regarding the reports hosted on the Cognos system. Next questions can pop up when modifying reports, changing the model, looking for objects and items used on reports etc.:

• Which data items are used on a report?
• Which hyperlinks, images are being used?
• Which filters are being used on which reports?
• What calculations are being used?
• Which prompts are being used?
• How do data items map back to the model?
• ...

Besides all the metadata related to your Cognos Connection environment, CoMetReporter also extracts, transforms and loads the Framework Manager model's metadata. This way you are able to report on items used in your model and you can automate specific documentation tasks:

• Automatically generate a mapping starting from the database layer, over the business layer to the presentation layer within your Framework Manager model up to data items used within a report.
• Perform bulk impact analysis when modifying your semantic layer.
• Automate release notes when publishing a new package to production by comparing the current version against the previous version.
• Create a package structure report for easy discussion with the business users about how the package should be structured in a logical way.
• ...