Automated Cognos Testing

Testing to Ensure Quality Cognos BI Assets

Maintaining accuracy and consistency of your BI assets is critical to the performance and reliability of your Cognos implementation.

An automated Cognos testing system, like MotioCI™, ensures superior performing Cognos environments by detecting issues early in the development cycle. Early detection helps you:

MotioCI is in a class of its own when it comes to testing capabilities for BI content. MotioCI has the most extensive features available for Cognos testing.

Limitless Cognos Testing Scenarios

MotioCI comes with pre-built testing criteria called Assertions, for you to use in your BI testing endeavors. These assertions allow you to verify a particular condition about a Cognos object or test for accuracy and performance. We also give you the power to customize and create your own assertions so that you can test what's relevant to your organization. For example, you can confirm that your dispatchers have consistent settings or you can compare report outputs to the result of SQL. The possibilities of testing scenarios are endless and easy to create within the Assertion Studio feature.

A few examples of the many assertion types provided by MotioCI:

  • Data validation: validate that report outputs have the correct data values.
  • Monitoring: continuously test the validity of all data sources and dispatchers
  • Enforce IBM “Proven Practices”: for example, ensure that security policies are defined according to accepted practices (Securing the IBM Cognos BI Environment).
  • Plus many more.

Regression Testing for Cognos Output Formats

You can also create regression tests for Cognos outputs, including SQL, HTML, CSV, XML, etc. You can compare outputs to other outputs residing on different Cognos instances, which is useful for comparing Cognos object performance between environments. Output testing is also very useful for identifying things that can affect performance such as:
  • Verifying SQL output doesn't contain outer joins
  • Confirming the output size remains within a specified range of its initial value, etc.

Continuously Test Your Cognos BI Assets

The MotioCI continuous integration capabilities allows you to automatically apply all configured Cognos tests at regular intervals (e.g. "run all tests every 2 hours"). The concept of Continuous Integration enables MotioCI to reduce the time and costs associated with BI development by proactively monitoring IBM Cognos environments and notifying you when a problem surfaces rather than relying on your end users to discover it.

What Can You Test with MotioCI?

MotioCI can test both executable and non-executable Cognos assets. Some executable content examples:

  • active reports
  • queries
  • analyses
  • reports

Non-executable content examples:

  • packages
  • data sources
  • dispatchers
  • folders

MotioCI's comprehensive Cognos testing provides the most reliable approach to validating Cognos content in the development cycle.

Client Case Studies

Achieving the most accurate and reliable BI implementations with Motio

"When our Dev content store crashed, we had just implemented MotioCI four months prior. If we had not had MotioCI, we would have been in a really, really bad situation. Right there, it paid for itself. We would have lost months worth of development effort that was only in the Dev environment...

"We could not manage our environment without MotioCI. The release team is no longer the bottleneck. Processes are going smoothly."

—Richard Wylde, Catlin

"Finding a solution which minimized risk and guaranteed that our existing security policies remained intact was very important to us. We were very impressed with the smoothness of the transition."

—Lisa Kelley, HealthPort

"MotioCI is an active insurance policy. It is doing exactly what we wanted it to do."

—Molly Doyle, University of Colorado

"The automated testing provided by MotioCI proved invaluable. With so many reports being created and modified, and the framework model and data sources evolving, it was a huge advantage to have MotioCI proactively pointing out inconsistencies and errors."

—Tim McGuire, Ameripath...

"Our users were wowed by the functionality of MotioADF. The self-service nature of this application has reduced our number of support requests. Even a user with little or no training is able to figure the interface out and immediately become productive."

—Tim McGuire, Ameripath...

"We had one report author delete a series of reports and could not recover them without restoring the entire Cognos Content Store, thus losing all of the work completed since the last backup. We know how valuable version control is and we knew we had to have it."

—Dustin Jordan,...

"By having MotioCI we directly save 500 hours per year on hiring external specialists, so we actually reduce our out-of-pocket costs."

—Rob Bakker, Eneco

"The relationshiop with Motio is an integral part of our rapidly expanding BICC, enabling holistic change control and proactive issues resolution on our critical reporting portfolio. It has and will continue to increase end user satisfaction and reduce total cost of ownership of our...

"With the complexity of our user interface, it would have taken us twice as long as it did if we had not started with Motio's software. They worked alongside of us to provide the best user interface for the product and the end results are quite impressive."

—Sheila Higgins, Avaya...

"I know of one instance several weeks ago where a set of reports went missing off the development environment and a ticket was submitted for the BACC support team. We were able to quickly show them how you can just restore the missing reports using MotioCI and their panic was over. It's...

"After we deploy to production, if something was missed in testing, or we have an issue, we can very easily roll back to a previous version using the MotioCI tool."

- Jon Coote, CIRA