Home

Automated Cognos Testing

Ensure the Quality of Your Cognos BI Assets

You need to trust that your reports and data are delivering accurate insights for smart decision making. However, maintaining the accuracy and quality of your data involves manual and unstructured testing processes that are slow and error-prone.

 

An automated Cognos testing system, like MotioCI, simplifies traditional testing methods so that you can rest easy knowing that you are delivering quality BI reports and assets.

Benefits of Automating Your Cognos Data Testing

Speeds Up the Testing Process

You can automate the testing of your checklist items on a repeatable, continuous basis and at any stage of the BI development cycle.

Reduce Costs

The sooner you catch errors with your reports, the cheaper they are to fix. By having continuous, automated testing in place, you can catch errors early on in the development cycle and repair them at a much lower cost.

Increase Time to Market

Your business users demand quick reports and dashboards. When you automate your testing process, you can reduce the bottleneck from manual testing and are able to get these quality BI assets into the hands of your user community.

Improve the Quality of Your Data

Because manual testing methods are riddled with human error, you end up with poor quality data. Regression testing tools do the checking for you, ensuring that your data is meeting your expectations.

MotioCI has the most extensive features available for Cognos testing.

Limitless Cognos Testing Use Cases

MotioCI comes with pre-built testing criteria called Assertions. These assertions allow you to verify a particular condition about a Cognos report or object. You also have the power to customize and create your own assertions in order to 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 what you can test for are endless.


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 create regression tests for Cognos outputs (SQL, HTML, CSV, XML, etc.). You can compare how outputs perform between different environments. Output testing is 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

You can automate all configured Cognos tests to run at regular intervals (e.g. "run all tests every 2 hours"). This 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 You Can 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

"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

"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