IBM Cognos Review

​Report Studio is a valuable feature but would be better with the ability to audit the SQL


Valuable Features

  • Jobs
  • Schedules
  • Auditing
  • Report Studio

Improvements to My Organization

Cognos gives a consistent single source answer for many users to retrieve easily. It allows for prompted value, so many questions can be answered.

Room for Improvement

Auditing the SQL to determine if there are any particularly slow points. Also allowing jobs to send email notification when complete with links to all the reports within the email.

Use of Solution

Seven years.

Deployment Issues

There are always some errors, but typically user errors.

Stability Issues

It is pretty stable, but bad queries can cause problems.

Scalability Issues

No issues encountered.

Customer Service and Technical Support

Customer Service:

6/10 as they usually get back quickly but rarely have a solution.

Technical Support:

6/10

Previous Solutions

I used MicroStrategy before, but I changed jobs because Cognos is a bigger company and would have more job opportunities.

Initial Setup

It is pretty straightforward. It doesn't take an expert to set up, but consultants will try to make it seem more complex than it is.

Implementation Team

We used a vendor team. They talked a good game, but I would rate them at a 6/10.

ROI

Don't know, but it's not cheap.

Other Advice

It's not as good a MicroStrategy for data analysis, but better for static reporting.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 Comment
baggottmUser

If you want to understand the performance of a single report or profile a set of reports then you need to use Cognos Performance Management Analysis (PMA). This is packaged with the Business Patterns offering and it used to be available on AnalyticsZone, but I don't see it there any more. No idea why.

Installation on top of SQL Server / Oracle instead of DB2 BLU might require assistance from IBM. They had to help us the first time. Once you understand the capabilities of this free utility it is absolutely amazing. It describes what is going on at a finer level of detail that anyone could want.

In summary. PMA is not trivial to configure but it is incredibly powerful at analyzing EXACTLY what is going on and why.

04 May 15
Guest
Sign Up with Email