IBM Cognos and Motio Best Practices Blog

Get Alerts When Your Cognos Performance Starts To Hurt

Posted by Sammy Ng on Mon, Oct 02, 2017 @ 04:57 PM


Motio ReportCard is a fantastic tool for analyzing and optimizing your Cognos performance. ReportCard can assess the reports in your environment, locate issues that cause a decline in performance, and present the results of how much performance can be improved by fixing the identified issue. Another important feature of ReportCard is the ability to continuously monitor your environment. This feature is known as “System Monitoring” and will be the focus of this blog, as we teach you how to set up alerts when performance goes outside of your expectations.

Read More

Tags: Cognos Performance, ReportCard

Discover Performance Issues in your Cognos Environment with MotioPI!

Posted by Kevin Strong on Tue, Aug 29, 2017 @ 11:13 AM


In this follow up to my first post about filters. I am going to briefly talk about number filters in MotioPI Professional. Without further ado, let’s dive into number property filters in MotioPI!


Number Property Filters

What are Number Property Filters

Number Property filters in MotioPI are just what they sound like, filters that act on any numerical property of your content. Examples include, but are not limited to: run duration of a report in seconds, the total number of recipients set on a schedule and the size of an output. I will talk briefly about how to set up a Number Property filter and then show them in action for the three examples I listed above.

Read More

Tags: motiopi, Cognos Analytics

Cognos Cleanup: Leveraging the Audit Database with MotioPI

Posted by Lisa Zavetz on Tue, Jul 18, 2017 @ 08:20 AM

As you use Cognos throughout the years, your environments tend to get cluttered. These extra reports cause Cognos to lag, and become less efficient. MotioPI, the free tool from Motio, can help get your Cognos environment back to running efficiently. MotioPI will not only help you to eliminate extraneous reports, but in this blog post, we will help you to identify the questions you may ask to ensure you are cleaning properly.

Read More

Analyze the Impact of Security Changes in Cognos TM1

Posted by Holly Rice on Fri, May 05, 2017 @ 03:24 PM

When it comes to getting some very common and crucial tasks done in IBM Cognos TM1, we found that there are many quite painful tasks to do. They are so painful, that the thought untangling Christmas tree lights for a living seems much more appealing! One such painful task we are going to focus on today is managing security in TM1. 

Read More

Tags: Cognos TM1, Agni for TM1

Recover a Lost Cognos Framework Manager Model (in 60 seconds or less)

Posted by Holly Rice on Wed, Mar 15, 2017 @ 04:52 PM

Have you ever lost or corrupted a Cognos Framework Manager Model? Have you ever wished you could recover the lost model based on information which is stored in your Cognos Content Store (e.g. a package which was published from the lost model)? You're in luck! You can use MotioPI (a free tool for Cognos admins) to recreate your Framework Manager Model's "model.xml" file with just a few simple clicks.

Read More

Tags: Cognos admin tools, Cognos framework manager model, motiopi

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

Easing the Cognos Upgrade Process

Posted by Lisa Zavetz on Tue, Jan 31, 2017 @ 12:00 AM

You know the drill: IBM announces a new version of their Business Intelligence tool, Cognos. You search the Cognos Blog-o-sphere and attend sneak-preview sessions for information on the newest release. It’s so shiny! Your reports will be so much happier in the latest and greatest Cognos version! But your excitement slowly slips away and is replaced by a nagging feeling in the back of your mind. Upgrading to the newest version of Cognos takes a lot of time, planning, and work.

There are so many circumstances that can affect how smoothly your upgrade goes. In a survey of over 100 cross-industry Cognos users, 37.1% said that managing the Cognos migration was their biggest challenge.


Read More

Tags: motioci, Upgrading Cognos

The Strategy and Tools You Need for Managing Cognos BI Performance [Webinar]

Posted by Holly Rice on Mon, Dec 12, 2016 @ 03:44 PM

When I get a brand new, flawless, unsullied anything- laptop, smart phone, car, BI software system, or whatever the item...I vow to keep it lean and mean and tell myself, "This time I'm not going to accumulate any unnecessary content, apps, data, trash, take out Chinese food containers, etc., and I am going to stay on top of regular maintenance." Right.

Read More

Tags: Cognos Performance, ReportCard

Setting Up a Gateway to Enable SSO for Cognos 11

Posted by Amir Sarir on Fri, Sep 30, 2016 @ 10:20 AM

How to Setup a Gateway for Cognos 11

A question that we very often get asked is this: “Does the Optional Gateway ever become a requirement?"

And the answer is, “Yes!"

One of the most common scenarios where having an Optional Gateway setup becomes mandatory is having single sign-on (SSO) setup. In this blog post I will cover how to setup an Optional Gateway in Cognos Analytics versions 11.0.2 and 11.0.3. Those who have followed IBM’s official document on setting up the Optional Gateway and are having connectivity issues might find this guide useful. IBM seems to have left out a couple of critical steps for setting up the Cognos ISAPI which I will cover towards the end. Let’s start with a background on the architecture.

**Please note, if you are on Cognos version 11.04 and up, the IIS configuration guideline can be found here. And to make this easier, IBM has a small tool you can download here to automate the process.

Read More

Tags: IBM Cognos, Cognos Analytics, SSO for Cognos

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