it_user504741 - PeerSpot reviewer
IBM Cognos Instructor and Consultant at a tech company with 51-200 employees
Vendor
It has the ability to model OLTP data sources with Framework Mgr. in weeks instead of building a data warehouse over a year or two.

What is most valuable?

It has the ability to model OLTP data sources with Framework Mgr. instead of building a data warehouse. Building a Framework metadata model takes weeks, while building a data warehouse takes 12-24 months.

The Framework model won't perform as fast as a properly designed and optimized DW, but it will give you accurate results with a much lower investment. Then, when your company is ready to invest in the DW, it can take the structure of the Framework model and map it to the DW tables, and all of your reports still work.

How has it helped my organization?

We are a Cognos-only training and consulting company so our business depends on Cognos.

What needs improvement?

The one that sticks out in my mind is the ability to search the relational data tree for query items (fields). I believe this functionality has been added in v11 (Cognos Analytics). The user interface in v10 is a little dated and not as tablet-friendly as some of the other viz tools. This has been greatly improved in v11.

For how long have I used the solution?

I have used it for three years.

Buyer's Guide
IBM Cognos
November 2023
Learn what your peers think about IBM Cognos. Get advice and tips from experienced pros sharing their opinions. Updated: November 2023.
745,775 professionals have used our research since 2012.

What do I think about the stability of the solution?

There are no stability issues as long as the image is properly built and fix packs are installed.

What do I think about the scalability of the solution?

I have not encountered any scalability issues.

How are customer service and support?

Over a few years, we have opened only a couple of tickets with IBM and all have been handled professionally and promptly.

Which solution did I use previously and why did I switch?

We have always used Cognos. We recently demo'd trial versions of Microsoft and Tableau against Cognos v11 and we still think Cognos is the better product for medium and large enterprises.

How was the initial setup?

Building the image for a new version takes several hours. Of course, IBM has cloud options that eliminate the need for keeping your own images.

What's my experience with pricing, setup cost, and licensing?

Like any enterprise software product, make sure you negotiate. IBM simplified the licensing in 2014, so I can't suggest any improvements there.

Which other solutions did I evaluate?

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

What other advice do I have?

Make sure your CFO understands the investment required for a successful BI installation that will give you one version of the truth, whether it's Cognos or another vendor. The investment is not only in software and hardware, but in the people who use it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user504054 - PeerSpot reviewer
Senior Business Intelligence Consultant at Aspen Associates
Consultant
It provides surprising results reporting a mixture of cost drivers, as opposed to only activity-based costs.

Valuable Features

We have found this software to be insightful in finding and defining true performance of products and services. The numbers give the details and there is no place to hide.

Improvements to My Organization

This software identifies normal product sales, margins and costing, which are basic key performance indicators. We then use this to identify service of customers and vendors. Recently “COST TO SERVE” reporting has been a “HOT” supply chain tool because this identifies the business activities and overhead costs. This reporting is NOT your (ABC) activity-based costing reporting, but a mixture of costing drivers, which usually provides surprising results.

We have also seen improvements in manufacturing processes because the tool identifies bottlenecks quickly. Most recently, the ability to have mobile reporting to our user site has been very important to drive down information.

Room for Improvement

We are excited about more features for cloud and web analytics:
- Cloud: Companies are really starting to embrace the cloud for running their business intelligence software. There is so much to choose from for supporting and servicing cloud users than 1-2 years ago.
- Web analytics: For me, this is where you see who is searching for your products and services. You can find out where in the country/world and know more about the user too. This gives you insight on your web presence and how your social media and marketing campaigns are performing. Also, who’s talking about your products and services and why? You can see what the issues are and what you are doing well.

Use of Solution

We have used Cognos Project for 20 years.

Stability Issues

I have not encountered any stability issues.

Scalability Issues

Once the users are trained on the product, everyone wants to use it, so it’s best when defining your in-house server or cloud that you incorporate future needs.

Customer Service and Technical Support

Technical support is excellent and very responsive. They have different levels of support for response time that can be purchased in addition to web help.

Initial Setup

We had training but were able to do the install in-house.

Pricing, Setup Cost and Licensing

Buy the software and licenses that you will need for the next 12-15 months.

Other Solutions Considered

We tried Microsoft’s offerings but found them not as full featured as Cognos.

Other Advice

Take time to understand your data. Decide which reporting must be from live data and what data could be taken from a data repository. Prioritize your reporting needs. Add proper time for validation and training.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a Cognos partner.
PeerSpot user
Buyer's Guide
IBM Cognos
November 2023
Learn what your peers think about IBM Cognos. Get advice and tips from experienced pros sharing their opinions. Updated: November 2023.
745,775 professionals have used our research since 2012.
PeerSpot user
BI Engineer at a media company with 1,001-5,000 employees
Vendor
The jobstreams makes grouping steps fairly easy, but lookup stability needs to be improved.

Valuable Features:

  • 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

Improvements to My Organization:

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).

Room for Improvement:

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.

Other Advice:

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user494622 - PeerSpot reviewer
it_user494622CSO, Digital Transformation | Vinci | Bosch at a tech services company with 201-500 employees
Real User

ColdLight is a leader in advanced analytics, predictive technology and machine learning science. At the center is Neuron, a secure and flexible automated learning engine that learns from massive amounts of data, discovers patterns and then delivers mathematically validated recommendations directly to the business teams that can take action. Neuron can be deployed as a SaaS cloud service, minimizing any infrastructure impact for our customers.

See all 5 comments
PeerSpot user
Principal Consultant at a tech services company with 201-500 employees
Consultant
It offers good back end delivery and end user device options, but it needs more graphic options and an updated UI.

Valuable Features

  • Data modeling
  • Back end delivery options
  • End user device options
  • Report designer
  • Scalability

Improvements to My Organization

There've been no improvements since implementation.

Room for Improvement

  • More graphic options
  • Its UI needs to be more 21st century

Use of Solution

I've used it for 10 years in various versions.

Deployment Issues

No issues encountered.

Stability Issues

No issues encountered.

Scalability Issues

No issues encountered.

Customer Service and Technical Support

Customer Service:

It's poor.

Technical Support:

It's fair.

Initial Setup

It was straightforward.

Implementation Team

We used an IBM partner who were good.

Pricing, Setup Cost and Licensing

Look at the TCO not just the sticker price.

Other Solutions Considered

No other options evaluated.

Other Advice

  1. Read
  2. Try
  3. Ask
  4. Repeat
Disclosure: My company has a business relationship with this vendor other than being a customer: We're an IBM partner.
PeerSpot user
PeerSpot user
Bi Consultant at a tech services company with 501-1,000 employees
Consultant
Cognos is the most stable BI environment, but it gets far too complex for advanced setup.

What is most valuable?

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.

How has it helped my organization?

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

What needs improvement?

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.

For how long have I used the solution?

I have been using it for more than five years.

What was my experience with deployment of the solution?

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

What do I think about the stability of the solution?

I believe that Cognos is the most stable BI environment.

What do I think about the scalability of the solution?

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

How are customer service and technical support?

Customer Service:

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

Technical Support:

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.

Which solution did I use previously and why did I switch?

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

How was the initial setup?

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.

Which other solutions did I evaluate?

We also looked at Microsoft BI.

What other advice do I have?

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.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partners
PeerSpot user
it_user32034 - PeerSpot reviewer
it_user32034User at a tech services company with 1,001-5,000 employees
Consultant

Can not agree more with you review.

See all 10 comments
it_user221220 - PeerSpot reviewer
Analyst in XBRL Projects at a financial services firm with 1,001-5,000 employees
Vendor
Good product with bad performance. We had licenses for all the features but users almost exclusively used the molap cube file.

What is most valuable?

The molap cube file is valuable.

How has it helped my organization?

We shared the molap cube file, which means can do analyses on their desktop.

What needs improvement?

Cognos is a good product with bad performance. We had licenses for all the features but users almost exclusively used the molap cube file.

For how long have I used the solution?

I've used it for 12 years, since v7.

What was my experience with deployment of the solution?

It has poor integration with other IBM products. In v7 (not in the IBM family), I overrode their upfront UI to integrate it into a websphere portal. In earlier versions, I still find these kinds of problems.

What do I think about the stability of the solution?

Almost all the time, we have a problem with Cognos stability and even our maintenance vendor can’t do anything to resolve it.

What do I think about the scalability of the solution?

I think Cognos have problem with their dispatcher performance. In v7, I overrode their impromptu options, to catch performance requirement, while in v8, again, I had to override their dispatcher management with our code. Finally, in v10, we didn’t make any changes to improve Cognos, and now our users leave it.

How are customer service and technical support?

Customer Service:

It's good.

Technical Support:

We are more expert than they are.

Which solution did I use previously and why did I switch?

We used Infobeacon and now we are using Cognos and Microsoft BI. We are currently looking for a better product and are evaluating Tableau.

How was the initial setup?

In 2003 It was very complex, and we must survive by ourselves because we can’t find any technical support for us.

What about the implementation team?

We always implemented it through a vendor, but until now, we are more expert than they are.

Which other solutions did I evaluate?

We evaluated Microstrategy as another option.

What other advice do I have?

Quality of data, flexibility and the performance of the tool(s) are the critical aspects of BI. Test the critical aspects by doing a proof of concept using a huge amount of data.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user195735 - PeerSpot reviewer
it_user195735System Analyst , Business Intelligence at a tech services company
Consultant

I have been working on IBM Cognos for over 8 years from the earlier versions to the most latest.This product has evolved a lot over time and has always been in pace with the business needs and data reporting requirements which have changed tremendously over the years.IBM Cognos is far more mature product than most of the competitors , but keep in minds its expensive.The product is now moving more towards self serve analytics and predictive analytics.

See all 5 comments
it_user191655 - PeerSpot reviewer
BI (Cognos) Developer at a pharma/biotech company with 501-1,000 employees
Vendor
​Report Studio is a valuable feature but would be better with the ability to audit the SQL

What is most valuable?

  • Jobs
  • Schedules
  • Auditing
  • Report Studio

How has it helped 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.

What needs 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.

For how long have I used the solution?

Seven years.

What was my experience with deployment of the solution?

There are always some errors, but typically user errors.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

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

Technical Support:

6/10

Which solution did I use previously and why did I switch?

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

How was the 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.

What about the implementation team?

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

What was our ROI?

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

What other advice do I have?

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.
PeerSpot user

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.

it_user185781 - PeerSpot reviewer
Solution Architect with 51-200 employees
Vendor
A ​good mix of abilities for reporting but ability to manage source code & environment deployment needs work

What is most valuable?

Good mix of abilities for reporting for both technical and non-technical users.

How has it helped my organization?

Dashboarding presentations of key metrics.

What needs improvement?

  • Ability to easily manage source code and environment deployment
  • Pricing model is frequently changing and hard to manage
  • Maintenance fees were based on a percentage of the base cost, not the discounted price we paid which was a surprise the first year

For how long have I used the solution?

Five years - Cognos BI 8 and 10

What was my experience with deployment of the solution?

Because the configuration options are wide, there are typically minor issues with an installation.

What do I think about the stability of the solution?

Not once it is configured correctly.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

6 out of 10.

Technical Support:

6 out of 10.

Which solution did I use previously and why did I switch?

Previous solution was built on an old technology and updates continue to be built over the same engine rather than an updated technology. Caused issues with programming.

How was the initial setup?

Complex, many options and variations available which is both good and bad.

What about the implementation team?

Through a vendor. Very good expertise.

Which other solutions did I evaluate?

Brief evaluation of other products, selection was based on discounted pricing at year end and high rating from Gartner.

What other advice do I have?

If you don't have staff with previous experience in this product, it's worth engaging a partner you help you with installation and configuration options, training and early implementation.

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

Regarding source code and environment management, there are some good thirty party add-on tools out there that solve this problem, and other problems such as large scale fine-grained security management.

Check out
MetaManager from Avnet Brightstar Partners (BSP)
CI/PI and other offerings from Motio
SecurityStudio from FirstQuarter
AuditProcessor from Genware Computer Systems
Varios Visn products from Envisn

I have used some but not all of these products.

Buyer's Guide
Download our free IBM Cognos Report and get advice and tips from experienced pros sharing their opinions.
Updated: November 2023
Buyer's Guide
Download our free IBM Cognos Report and get advice and tips from experienced pros sharing their opinions.