COGNOSANT

Cognosant is an automatic report generator and download client for use with IBM Cognos. It was primarily developed for use by Arkansas Public Schools running Cognos version 10, but is fully configurable and should work with other Cognos installations.

Features

Installation and System Requirements

While still currently in Pre-Release testing, the latest version of the Cognosant Installer for Windows is avaiable here:

Download Cognosant.0.9.6857.msi

Cognosant requires the Microsoft .NET framework version 4.6.1 or later (included with Windows 10 version 1511 and newer)

Configuration

When running Cognosant for the first time, the initial configuration screen will prompt for the following settings:

Adding a Report

Before adding a report to Cognosant, you will first need to ensure that it is properly configured within Cognos:

  1. Click the “Set Properties” icon next to the desired report.

  2. On the second tab (labeled either Report or Query) set the following options:
    • Default Action - Select “Run the report” to download live data from Cognos.
    • Prompt Values - Click on “Set…” and specify the appropriate values.
    • Optional - Check the “Override the default report options” box and set the report format as desired
    • Click OK to save these settings and return to My Folders

  3. Click the “Set Properties” icon again next to the same report.
  4. On the General tab, click the “View the search path, ID and URL” link.

  5. On the “View the search path, ID and URL” box, highlight and copy the entire “Default action URL”

  6. Close the “View the search path, ID and URL” box.
    If desired, you can now return to the Report / Query tab and modify the “Default action” and “Report options” settings. Once the URL has been copied, those values will not affect Cognosant. However, any saved “Prompt values” must remain set in order for Cognosant to function.

    You are now ready to add the report to Cognosant

  7. In Cognosant, press the “Add Report” button.
  8. In the “Add New Report” screen, press the “Paste” link to paste the copied “Default action URL” into the URL box.

  9. In the “Save to” box, enter the location to save the downloaded reports. If you enter a directory path only, the Cognos report name will be used as the file name. You can also enter a complete path plus the filename to be used in place of the Cognos report name.

  10. Click OK
  11. Optional (but Recommended) Select the newlay added report and click “Download Selected” to verify that the report downloads correctly.

NOTE: The “Enabled” checkbox determines whether or not the report is downloaded when using the “Download All” command. This allows you to keep reports in your list without downloading them in every scheduled pull.

Command-Line / Scheduled Downloads

You can schedule downloads using the Windows Task Scheduler or script them in PowerShell by using the command line version.

NOTE: Cognosant’s settings are unique for each user, therefore any scheduled task must be run under an appropriately configured user account.

All product names and trademarks are the property of their respective owners and are in no way associated nor affiliated with this project or website.