Most Cognos developers have been confronted with this situation before: A report runs perfectly fine in the Cognos Development or Test environment, but has some sort of issue in the Production Cognos environment. This scenario generally results in the Cognos team asking the question, "What are the differences in this report between the Cognos environment where it works (Development/QA) and the Cognos environment where it has an issue (Production)?".
IBM Cognos and Motio Best Practices Blog
Have you ever needed to update the parameters for a large number of report views? This can be very time consuming in Cognos Connection. For example, imagine a report which expects 15 parameters (normally populated via its prompt screen). Since filling out 15 parameters each time they execute this report is a bit taxing, its pretty common place for users to save report views of this report (to capture all of their parameter selections, and make launching the report much easier in the future).
With MotioPI Pro's Property Distributor you have the ability to modify the properties on any Cognos object in bulk. In today's example, we'll use this feature to update the package associated with multiple Cognos reports in one fell swoop.
MotioPI Pro provides a quick and easy way to mass update the Default Action for a set of Cognos reports.
As a Cognos modeler I'm sure many of you have had this experience: After your latest round of model updates, you publish a new version of a package from Framework Manager. This new version of the package accidentally breaks a ton of reports.
Let's face it - this is pretty easy to do (especially for reports you haven't thought about in a while).
Wouldn't it be nice if you could press a button and batch validate all Cognos reports which are associated with this package...?
Well, you're in luck because MotioPI (the FREE tool for Cognos admins) allows you to batch validate Cognos reports with just a few simple clicks. Here's how:
MotioPI gives you the ability to search for schedules associated with reports, jobs, report views, and query objects in Cognos.
Have you ever needed to update an image or change the footer text on hundreds of reports? Have you ever refactored your framework model and needed to change the query item names across all reports which are built on it? Have you ever renamed a report that is referenced as a drill target in many other reports?
If you have ever faced one of these scenarios, then you know how tedious it can be when you have to manually apply the same change across a large number of reports. This is where MotioPI Pro's Search and Replace panel can save you a ton of time (and spare you a great deal of aggravation.)
This blog entry will demonstrate how to use the MotioPI schedule panel to quickly find all schedules which deliver Cognos outputs to a particular recipient.
The PI schedule panel lets you query for all scheduled report executions in a given Cognos instance. The results allow you to peruse various bits of information on each schedule, such as the recipient emails (or user names), start date, end date, frequency, owner, etc.