IBM Cognos and Motio Best Practices Blog

Kevin Strong

Kevin Strong works with all things IBM Cognos and MotioPI. As a 2-year veteran at Motio, he solves customers pain points with Cognos by teaching them how to get the most out of MotioPI. Kevin works with the PI software team to discover and document Cognos quirks, and he designs and implements new features for MotioPI.
Find me on:

Recent Posts

Using MotioPI Search Filters to Work More Efficiently in Cognos

Posted by Kevin Strong on Thu, Feb 23, 2017 @ 11:20 AM

Filtering In MotioPI

One of the most powerful features in MotioPI is its ability to filter search results. Intelligent usage of filters will enable you to answer complex questions about your environment easily via MotioPI. Using filters isn’t always as simple as just clicking "Search." In this blog post, I’ll provide general instructions on how to use filters, and then go in depth on a few filter types. Specifically, I am going to talk about text property filters.

What can filters do for me?

Read More

Tags: Cognos admin tools, motiopi

How to Identify Cognos Reports with Embedded SQL

Posted by Kevin Strong on Wed, Sep 07, 2016 @ 09:30 AM

A common question that keeps getting asked of the MotioPI Support Staff is how to identify IBM Cognos reports, queries, etc. that utilize in-line SQL in their specifications. While most reports leverage a package to access your data warehouse, it is possible for reports to run SQL statements directly against the database, bypassing your package. Let's talk about why it's important to know which reports have embedded SQL.

Read More

Tags: Cognos management, Cognos admin tools, IBM Cognos, motiopi

Converting Reports to Fully Interactive Mode in Cognos Analytics

Posted by Kevin Strong on Thu, Jun 30, 2016 @ 12:00 PM

The launch of IBM Cognos Analytics marked the release of many new features along with phasing out many mainstays of previous Cognos versions. One of these new features is a type of report, called a “fully interactive” report. Fully interactive reports have additional capabilities when compared to reports that are not fully interactive reports (sometimes called “limited interactivity”).

So what is a fully interactive report? Fully interactive reports are a new way to author and view reports in Cognos Analytics. Fully interactive reports enable live analysis of the report. This live analysis comes in the form of toolbars that enable the user to filter and group information or even generate charts. All this without re-running your report!Image Source:IBM Analytics

Read More

Tags: update multiple Cognos reports, motiopi, Cognos Analytics