All geek questions in one place

Is automatic unit testing possible on Cognos?

Does anyone know if there is any tool or way to apply automatic module testing in a report studio and / or frame manager?

When some regression tests are required and I need to run the report on the report in the traditional way, it really bothers me.

Respectfully,

Evandro

+4
source share
3 answers

In the standard out of the box configuration, there are no tools that could do anything automatic in Cognos 8 (it seems). In theory, however, the Cognos 8 SDK could be used to write and run automated unit tests for reports using something like JUnit. In addition, if you basically check how changes in the database affect the result sets of reports / queries, you can extract SQL from each report and run automated tests separately from the Cognos environment.

0
source

There is such a tool - take a look at MotioCI. The focus is on automated testing, version control, and release management for Cognos environments.

On the automated testing side, you can configure claims for Cognos reports that provide:

  • The report execution time is at a certain threshold (for example, “launch this report, and these parameters should always be filled in after 20 seconds or less”)
  • The report generates the expected result.
  • The report adheres to established organizational standards for fonts, color schemes, permitted images, etc.
  • Etc.

You can configure MotioCI tests that will run at periodic intervals (for example, every 4 hours) in your development environment and configure it to notify you if something starts to fail. This gives you an early warning when a report begins to diverge from expected results or performance levels.

This is truly the tip of the iceberg for implementing continuous integration for Cognos BI environments (CI is the central theme in almost every Agile methodology).

For more information about MotioCI and automated testing in Cognos, see:

Cognos Automated Testing

To learn more about continuous integration for business intelligence, review the following white paper:

Continuous Integration for Business Intelligence

Greetings

A spear

+2
source

One possibility is to use Selenium to check the HTML output of your reports. Selenium is not trivial to configure, but it is fairly widely known / used / supported.

Wikipedia article about Selena

0
source

Source: https://habr.com/ru/post/1307789/

More articles:


All Articles