IBM Cognos and Motio Best Practices Blog

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.

Here's a list of objects in Cognos Connection. In order to view the permissions for a Cognos object you have to click on the "Set Properties" icon (shown below), then select the "Properties" tab, and then choose the "Permissions" tab. 

Cognos Connection policies
Click to enlarge

Below you see the all of the permissions for this specific Cognos object. Depending on how many Cognos objects you wanted to view, you would have to repeat this process for each individual object, which could take hours.  

Cognos policies
Click to enlarge

MotioPI allows you to streamline this process and review multiple Cognos objects in a list form so you can smoothly switch between each object with a click. MotioPI also allows you to generate an output of a selection of Cognos objects and their permissions.

Here's an example of how to view the permissions on folders or packages in MotioPI. 

1. After selecting the "Content" tab, uncheck "Report" and check the box for "Folder" and/or "Package". (You can view permissions for packages, folders, reports, schedules, jobs, etc. in Cognos.)

View Permissions
Click to enlarge

 2. Select "Submit"

Submit Permissions
Click to enlarge

 3.  Highlight a Cognos folder or package you are interested in viewing.

Select Cognos Folder
Click to enlarge

4.  The policies and permissions are displayed here:

Displayed Policies and Permissions
Click to enlarge

 You could also filter the results if, for instance, you are looking for every Cognos object that is visible by a particular Role. To use the filter function simply select the "Filter" button, double-click "Property Value," and then use the drop down menu to choose "Policies". You can then type in the value you would like to search for and select "Ok".

Filter Results
Click to enlarge

 If you want to view the resulting list of Cognos objects outside of MotioPI, you can generate an export of all of the resulting folders/packages by choosing "File" and then "Export Output". Be sure to check the "Show Policies" box. You can then choose to save the output as a csv or an html file. CSV files are more easily manageable with Excel or Google Sheets.

Generate an Export
Click to enlarge

By using the Content panel in MotioPI, you're able to efficiently view the permissions for dozens of Cognos objects in very little time, rather than individually opening each object in Cognos Connection, closing the object, and starting the process all over again, saving yourself quite a bit of time and energy!

Tags: Cognos management, Cognos admin tools, motiopi