IBM Cognos and Motio Best Practices Blog

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.

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

Improve How You Solve Cognos Report Access Issues with Impersonation

Posted by Lisa Zavetz on Thu, Jul 28, 2016 @ 09:00 AM

You check your emails Friday afternoon and see that Ursula has lost the ability to see some important reports after a new release. Ursula desperately needs these BI assets available Monday morning. You can't walk over to Ursula’s office though, because she is in New York and you are in Honolulu.

Read More

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

Testing Cognos Data Source Connections

Posted by Holly Rice on Tue, May 31, 2016 @ 04:34 PM

PROBLEM:

A Cognos user (let's call him "Carlos") tries to run a report but receives an error message indicating that the attempt to connect to the data source failed. Carlos alerts you, the administrator, about the issue and you are now tasked with finding the cause. Meanwhile, Carlos' workflow is interrupted and he must switch gears to something less important until the data source issue gets resolved for him to be able to access reports again. What if you could avoid the frequency of this data source connectivity problem hitting Carlos and the rest of your Cognos users? Well, you can and we'll show you how in this blog post. 

We recently broadcast a "skills session" webinar for testing IBM Cognos administrative objects with MotioCI software. One of the featured objects we demonstrated how to test was data source connections. Data source connectivity can be automatically and continuously tested by MotioCI and comes preconfigured with the software, out-of-the box. Let's take a look...

Read More

Tags: motioci, Automated Cognos Testing

Here's Why You Should Attend the IBM Vision Conference

Posted by Holly Rice on Thu, Apr 28, 2016 @ 02:00 PM

It seems like there is a different tech conference every month these days, so sifting through the noise and determining which one is truly beneficial for you and your personal career growth (along with which events will benefit your organization) is a task not to be taken lightly.

Read More

Tags: Cognos TM1, Cognos Analytics, IBM Events & Conferences

Improve How You Edit IBM Cognos Framework Manager Model Elements

Posted by Holly Rice on Thu, Mar 31, 2016 @ 04:33 PM

One of MotioPI Pro's basic fundamentals is to improve workflows and how administrative tasks are done in IBM Cognos in order to "give time back" to Cognos users. Today's blog will discuss how to improve the workflow around editing Cognos Framework Manager model element names, descriptions, and tooltips. We will demonstrate a MotioPI Pro feature that makes it easy to update the information that business users see- model terminology elements.

Read More

Tags: Cognos framework manager model, motiopi

Preventing Broken Shortcuts in Cognos Using MotioPI Pro

Posted by Holly Rice on Thu, Feb 25, 2016 @ 03:15 PM

Creating shortcuts in Cognos is a convenient way to access the information you use frequently. Shortcuts point to Cognos objects such as reports, report views, jobs, folders, and so on. However, when you move objects to new folders/locations within Cognos, the shortcuts that reference them turn into broken links. You would then have to go into Cognos and recreate all of the shortcuts to those objects that were moved. 

Or, you could conveniently move the Cognos objects within MotioPI Pro in order to prevent broken shortcuts and avoid the pain of having to recreate them. 

Read More

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