IBM Cognos and Motio Best Practices Blog

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

Security for IBM Cognos- How Much is Too Much?

Posted by Lisa Zavetz on Thu, May 28, 2015 @ 09:00 AM

There is often a misconception of the idea of security. Many think security means that your system can’t be hacked, and your personal files are not accessible. Security means that nobody can get your great aunt’s secret banana bread recipe. You can never be too secure, right?

Read More

Tags: Cognos management, IBM Cognos

Cogratulations Jeff Hanna, Winner of the Cognos Admin Ninja Award™

Posted by Holly Rice on Tue, Oct 14, 2014 @ 09:26 AM

On September 30th, Hug a Cognos Admin Day, we hope you hugged and celebrated your beloved, hardworking Cognos admins! In honor of this special day, we would like to recognize an individual Cognos Administrator who has shown exceptional skills and merit, by awarding him with the Cognos Admin Ninja Award. We received many worthy nominations for this award and while it was difficult to choose just one winner, we decided upon Jeff Hanna of Optum. Congratulations, Jeff!

Read More

Tags: Cognos management, IBM Cognos, Hug a Cognos Admin Day, Cognos Ninja

How to Find Permissions on Folders, Packages, etc. in Cognos

Posted by Adrienne Young on Wed, Jul 16, 2014 @ 03:45 PM

We've heard from several Cognos users recently who would like to be able to quickly retrieve and view the permissions for more than just Cognos reports. While you can do this in Cognos Connection, it will only allow you to view permissions on each Cognos object one at a time.

Read More

Tags: Cognos management, Cognos admin tools, motiopi