IBM Cognos and Motio Best Practices Blog

Free Form Data Analysis vs. Data Governance and how it Correlates to a Japanese Delicacy

Posted by Lisa Zavetz on Tue, Feb 25, 2020 @ 09:45 AM

Standing before the screen, I carefully reviewed my options for udon. It was my first trip to Tokyo, and the lure of the wheat noodles was too strong. I made my lunch selection, grabbed a receipt marked in Japanese, and walked inside the noodle shop.

Read More

A Deeper Dive into Qlik's Statement of Direction: How Check In/Check Out Enhances Continuous Integration

Posted by Lisa Zavetz on Tue, Feb 18, 2020 @ 02:15 PM

Qlik Sense announced the addition of check in/ check out to their statement of direction, a huge step forward in applying Continuous Integration to your BI practice. At a technical level, Continuous Integration is the process that monitors the project’s source code repository. When a change is detected, a clean copy of the source is pulled, rebuilt, and regression tests are run on it. Any errors are quickly made visible, so developers can detect issues at a much faster pace. This process saves you money because defects and incompatibilities cost less to fix when they are caught within minutes of their introduction.

Read More

Converting from CQM to DQM: A Cognos Customer's Journey

Posted by Michael Daughters on Thu, Jan 30, 2020 @ 01:03 PM

Whether you’re considering moving to IBM Cognos Analytics on the Cloud, wanting to use JDBC drivers instead of a native database client, or just wanting greater visibility into performance-related characteristics of queries, adopting Dynamic Query Mode is a great idea.

Read More

Tags: Cognos Analytics

CQM to DQM and Why the Transition Isn’t as Hard as You Might Think

Posted by Lisa Zavetz on Mon, Oct 28, 2019 @ 11:35 AM

Transitioning from CQM to DQM. It’s a hot topic, and one we have yet to discuss.

Not dissimilar to a Cognos upgrade, you are looking into switching to DQM because it supports new database types, enhances performance, and is required for Cognos on the Cloud! But of course, the newest, best technology is worthless if your reports don’t run and/or the data is inaccurate.

Read More

An Intuitive Clean Out: How Organizing Photos Relates to a Cognos Upgrade

Posted by Lisa Zavetz on Thu, Aug 29, 2019 @ 12:01 AM

I got a notification on my phone that my storage space was running “dangerously low.” My initial thought was, “wow, what a pain.” I was not looking through spending my whole Saturday sorting through my phone and deleting stuff before I could use the camera feature again. So I clicked on the notification, saw this, and took a screenshot:

Read More

Product Spotlight on Soterre: Version Control and Deployment for Cognos TM1/Planning Analytics

Posted by Lisa Zavetz on Sat, Apr 20, 2019 @ 10:21 AM


Our Soterre product was conceptualized by, well, you! After constantly being asked, “Hey, can you make MotioCI but for TM1/Planning Analytics?” we knew something had to be done.

If you aren’t familiar with MotioCI, the highlights include version control and automated deployments for Cognos BI. This has saved countless hours for our customers each week by better managing their BI workloads. It has also improved the management of their Cognos environment and helped to reduce stress in their Cognos community.

Read More

We Answer Your Motio “In the Cognos Box” Questions

Posted by Lisa Zavetz on Wed, Mar 27, 2019 @ 10:00 AM

Unless you’re untouched by our marketing team (and really, why would you want that?) then you’ve heard of this “In the Cognos Box” announcement. And the more it’s promoted, the more questions come our way. We love the enthusiasm coming from our customers and friends, and want to compile one solid place to answer the most popular questions!

Read More

How to Add a Footer to a Group of Cognos Reports

Posted by Holly Rice on Wed, Oct 24, 2018 @ 05:21 PM

Let’s say you need to add the following confidentiality statement to each of your footers in dozens of existing Cognos reports:  The information contained within this report is proprietary and confidential. No part of this report may be disclosed in any manner to a third party without prior written consent.”

Read More

Tags: Cognos admin tools, update multiple Cognos reports, motiopi, mass update Cognos

Locate and Mass Update Fonts in ALL your Cognos Reports, Quickly and Easily

Posted by Sammy Ng on Wed, Aug 08, 2018 @ 01:08 PM

Imagine your organization has decided to update their brand, and you’re tasked with updating the fonts on ALL company-wide reports that aren’t Arial or Helvetica with Arial. But how would you proceed to accomplish this herculean task? The average Cognos customer has between 10,00 and 15,000 reports in their production environment. So you would have to dive into tens of thousands of reports and manually edit each and every one! MotioPI Pro provides a more efficient method for mass updating all your Cognos BI content. Here is a look into how to update your fonts.

Read More

Tags: cognos change management, getting started with MotioCI, IBM Cognos, Cognos Analytics

How To Use MotioCI “PDF Diff” To Accelerate The Cognos Upgrade Process

Posted by Sammy Ng on Wed, Jun 20, 2018 @ 11:00 AM

Locating errors in report outputs can be a difficult and complex task. It’s especially challenging if your Cognos system hosts a sea of reports! MotioCI can journey deep into your Development, Production, and QA environments to fish out error-filled report outputs.

Read More

Tags: Cognos management, getting started with MotioCI, Automated Cognos Testing, Upgrading Cognos