IBM Cognos Reviews

• Advanced, enterprise-level data modelling
• Reporting
• Request routing
• Integrated security
• Auditing
• Jobs and scheduling
• Alerts and agents
• Content distribution

Centralised, balanced, scorecard-based dashboards with drill-through to detailed OLAP; datawarehouse; and operational reports keep the organisation focused on KPIs.

It is struggling to compete with the front-end ease of use and visual appeal of QlikView and Tableau.

I have used it for 14 years.

I have not encountered any stability issues.

I have not encountered any scalability issues.

Technical support is good (7/10).

I did not previously use a different solution.

It is a mature, full-featured enterprise product and as such requires detailed configuration/administration knowledge to set up.

Before choosing this product, I also evaluated SQL Server Reporting Services, Tableau, and QlikView.

It provides value for larger enterprises.

• The jobs, which can be used easily, to place the right SQL-statement in the required order, makes monitoring them a lot easier
• The jobstreams, makes it possible to group the jobsteps effectively, and in the right order
• the scheduler, which makes it easy to run the jobs and jobstreams at any convenient moment
• The lookups, if working correctly (they can be unstable), provide a good way to ensure referential integrity between fact tables and dimension tables

It gave the organisation the possibility to have a closer look a the data in a more organized way. If they would have had the stability to see it through, they probably would have required insights in their (in)efficiencies that greatly would have improved the effectiveness and efficiency of the core activities (it was a callcenter).

The stability of the lookups is not very good, and really needs improvement. The tool forces you in the direction of a datamart/Kimball architecture. If that is not the architecture that you want, it requires a lot of tricks to fold it to your needs. When you use hierarchies and dimensions, you are basically more or less forced into building these first, before building the fact tables. If these dimensions need adjustment or modifications, implementing these is a very complicated delicate and a faultridden operation.

The most effective way to get a sturdy result in the Cognos Datamanager, is to leave out the fancy stuff. Only use the jobs and jobstreams (and of course the scheduler to run them). Guard referential integrity by making the correct joins in the queries which are in the jobs (and putting these of course in the right order). Then, Cognos Datamanager can be very useful, sturdy, and flexible.

I understand from fellow forum user that the Cognos Datamanager will not have technical support from IBM anymore starting from 30th September 2015. If you haven’t made a choice yet for a datawarehouse solution, choosing the Cognos Datamanager could give you serious support issues in the not so far future.

In a more general sense, why do you want a datawarehouse? If you want to resolve issues with data quality, a datawarehouse can make these visible, but there are a lot cheaper ways to achieve this. And, of course, knowing about the problem, but taking no steps to tackle these, won't solve anything. If you want a sturdy, reliable, comparable, standardized and well organized data, a datawarehouse is a good option. However, it takes time and effort. However, quite a lot of organisations use the Cognos Datamanager. Migrating to another environment is a costly and potentially risky undertaking. I expect that a lot of Cognos Datamanager applications will probably be in use for many years to come. Some useful dinosaurs, such as COBOL, still survives. I think the Cognos Datamanager can easily go that way too.

There are too many features I like in Cognos to mention, but the most valuable one is a tool has a new set of features called Cognos Insight. It need a separate article to talk about.

As a consultant, I have seen many cases where Cognos has helped organizations to increase business performance, and support managers in decision making.

The main improvement required is to help users with the full vision about the product according to their need. Also, the scale of the stuff on their website that is hidden needs to be changed. They also a need technical person who is very interested in the product, and understands it. The technical stuff is improving too fast, and the IBM lab is working too hard.

I have been using it for more than five years.

I can't remember any issues I have faced that I have not been able to resolve through their website.

I believe that Cognos is the most stable BI environment.

Cognos has the most scalable options in the market. It has options for all, from personal users, to the most complex enterprise organizations.

Customer service is fair compared with the abilities and size of the product.

I would rate it as 7/10 as it is rare to find unknown issues that have no resolution, but if you find one, or you did something wrong, and try to get help it will take some time.

I used Microsoft BI and I switch to Cognos when I found that I wasn't able to satisfy some customers needs.

The setup now is straightforward. The complexity decreased by time until it reached a very good level, but it gets far too complex for advanced setup.

We also looked at Microsoft BI.

Before you start, request advice so you can select the most suitable option for you. You should do this because there are too many options in this product and you may pay for features that you will never use.

Framework Manager.

IBM Cognos is a Decision Supports Tool that draws an organization's picture and gives you a general scene overview of your organization.

4 years.

Yes, Report Studio's charts are not flexible size so you have to give constant size to chart.

Yes, It was the IBM Cognos mobile application server performance issue. We have to restart everyday.

No I did not.

In Turkey, IBM Customer Service and Sales strategy is very bad. Their level of customer service quality is very very low.

Their technical support method is wrong because they only give technical support to partners that are consultant firms . The partners' priority is money so it reduces the quality of service.

Now, my organization is switching IBM Cognos to OBIEE because of IBM Approaches.

IBM Turkey signed a project that is Legal Reporting with my organization but they could not finish the project. However they wanted to take their money out of the project so my organization decided to never use IBM's products.

The initial setup is a complex one that needs an administrator.

Both of them according to the project. We rated their level of expertise with POC.

We compared products with Gartner Reports.

Framework Manager is the best Metadata Modeling Tool and also Report Studio.

Cognos Analytics, or CA for short, is an enterprise level reporting platform. At the most basic level you can use it to build reports. But taking a broader look allows you to see that it covers a vast amount of ground through many different modules.

The basic platform comes with several meta-modelling tools.

Framework Manager allows you to build relationships between physical database tables, and even a ROLAP solution. Great for detailed or minor aggregation.

Transformer is a basic cube modeling software. Best for building dimensional models over smaller datasets (a few dozen GB), it works extremely well.
Dynamic Cubes is a more advanced ROLAP solution that has intelligent aggregate, query, data, and result set caching. In my experience this works best with larger data, in the TB or PB ranges.

Data Modules. This is an advanced user level modelling. It allows end users to build and cache datasets which they can then use in ad-hoc dashboards and reports.

On the reporting side it, again, has a few tools.

Report Studio is the professional reporting environment. This allows BI Developers to create advanced reports, dashboards, analytical applications. While it does take some training, the effort is well worth it.

Dashboards work against the data modules. T allows advanced users to work with the data modules they've built previously to build dashboards. Users can quickly drag in fields directly onto the canvas to make graphs, prompts, data grids. Interactivity is automatically defined (but can be defined manually) to allow users to filter one group of objects by clicking on another.

Story is a tool used to create presentations. You can use elements from other reports to make a slide show or "guided journey".

There are a few other tools, like Event Studio which can be set to automatically perform actions based on query outputs. There is a graph building tool that allows you to build graphs that developers can use in their reports.

As a consultant, I've had the pleasure of working with a very wide range of clients with very specific needs. So far, Cognos has not failed to meet their needs, and surpass their expectations. The beautiful thing about Cognos is its flexibility.

One client, a government research organization, uses the tool to track specific incidents. When certain criteria occur, specific reports should be emailed. An SMS should be delivered. The researchers needed to be able to view the incidents from as many different perspectives as possible, and quickly go from one perspective to another without losing the context. Dynamic filtering and linking prevailed here.

Another client wanted to expose Cognos to the general public, embedding report outputs in their own portal system. This required a heavy security presence, with redundant levels of data and object security. Even if a report developer did leave a hole in the report, malicious end-users would never be able to get any data they weren't permitted to see. Cognos withstood the probing of professional pen-testers with admirable results.

As with all products, I have run into bugs; some severe enough to derail the project until IBM provided a patch. IBM Support can be slow at times, but they can usually deliver in a timely manner. Fortunately, show-stopping bugs are few and far between.

I have worked with IBM Cognos for many years, across several different product versions. The most recent being IBM Cognos Analytics 11.6.

Cognos presents interesting scaling opportunities. Additional servers can be loaded and unloaded as needed, and there are many ways of routing report runs. For larger organizations, it's possible to optimize report runs by having one branch of an organization always run reports from a single server.

Support is not cheap, and consultants (hello!) generally charge a few appendages. This is, of course, a matter of getting what you pay for.

The best piece of advice I can give to companies considering Cognos is to factor in the cost of training or consultants. Cognos, despite what some sales people may say, is not an easy tool to start with. It requires a hefty amount of investment to implement. But with proper training, and working with the tool's strengths, the return is well worth the price.

The ability to interface with multiple server types (databases) to retrieve data and report on that data in an all-inclusive environment is beyond a doubt the best feature. The reporting interface takes getting used to, but once you familiarize yourself with it, you can create some truly amazing graphical and informational reports.

BI has allowed our product to become open ended as far as the client data is concerned. We have proprietary reporting that is standardized but doesn’t capture everything. BI expands that functionality to include any and all customization a client may have and still get their data.

The GUI for reporting isn’t very user friendly, so beginners struggle with feeling overwhelmed when seeing it for the first few times. I spent my first two years just getting used to where everything was and how to script simple things without looking them up. A better dictionary of examples for functions would have gone a long way with helping me.

They’ve improved it and it’s much better than it was, as well as the tooltips on the page, so I’m thinking they had similar feedback in the past. When I engage new clients on the product, though, they are almost always overwhelmed by the interface and I don’t have a good solution other than redesign. They could create a secondary Page Design pane that is simpler for beginners. They could even merge Query Studio with Report Studio, and as you familiarize yourself with the Query pane and need a little more functionality, you can flip to the Report Studio pane. I would prefer a secondary pane option over an entire redesign since I’m familiar with the current structure.

I’ve used Cognos BI for over seven years now.

I have not encountered any stability issues.

I have not encountered any scalability issues.

I personally have had no problems with IBM tech support, though my experience is from a reporting standpoint not an implementation standpoint.

I did not previously use a different solution.

The only advice I can give here is that there are several third-party companies that will handle implementation as well as provide continued support post-production. I recommend doing your homework and hiring one of them to take care of implementation and support, if you don’t have a dedicated team to do so internally.

Before choosing this product, I did not evaluate other options.

There is a huge cost up front to purchase and get it off the ground, but once you have it, you won’t regret it. To have access to all of your data at your fingertips is impressive and I think it’s a must have for medium and large companies (+500 employees).