Try our new research platform with insights from 80,000+ expert users
it_user502383 - PeerSpot reviewer
Senior BI Architect at a healthcare company with 10,001+ employees
Vendor
Transformer allows you to pull large amounts of data together.

What is most valuable?

Cognos contains many components that make up the entire Cognos suite.

The starting point is the meta data designer, which is Framework Manager.

Framework manager allows you to pull in database tables from any type of database, this is referred to as the ‘Database Layer’. Then you create the Business Layer where you update the column names with ‘business names’ and remove the geek speak or database names. You can also include data transformations and table joins in this layer. Finally you create the Presentation Layer that points to the Business Layer. The presentation layer is usually the only layer that is published in the Cognos package.

Cubes contain data hierarchies and time dimensions to allow a report consumer to ‘click and drag’ the data elements that they want to analyze to their reports.

Transformer is the product that allows you to pull large amounts of data together, to allow clients to slice and dice their data any way that they want. Report Studio allows for sophisticated reporting. Each of these is valuable; there is not just one that is more valuable than the other.

How has it helped my organization?

We developed sophisticated reports in the fundraising area, which pulls in data from many different databases and presents graphs, charts and summary financial information over any time period that the person wants to see. This set of reports are run or used on average 15,000 times per month by hundreds of end users.

Another example is building financial data using cubes. The cubes contain 11+ years of financial data and we have the add-in for Microsoft Excel, which allows end users to build their own ad-hoc reports for trending and analysis.

What needs improvement?

Right now, we are in the midst of implementing a brand new version of Cognos, named Cognos Analytics. This version is very, very different from prior versions. We are finding ‘undocumented features’ on a daily basis and reporting issues to IBM. We are working thru the issues, but it is very stressful on us, finding out functionality that was in the previous release but is missing now in Cognos Analytics version 11.

Here are just a few examples of issues that we are facing as of today! We have identified other issues, which have been resolved or we have workarounds.

- In our CA production environment, we imported reporting content that included saved output of financial reports. The saved output did NOT import and therefore users will not be able to pull up the reports in production! This works in our other CA environments, but failing in production!

When you have a saved output report that contains links to drill thru reports and you want to open them in a new browser window, it fails! You have to go in and modify the reports to open in the same window, so now the user cannot see the original report that they clicked on.

You also lose the ability to export reports to Excel or PDF when you have drill thrus to a new window.

If you run a report, have it emailed out and you attach a link to the report in the email, it fails only in our production environment.

The Search and Select prompt fails on the prompt page.

For how long have I used the solution?

I have used it since 2005, so 11 years now.

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

What do I think about the stability of the solution?

The product is stable, but we continue to find issues due to the product’s newness.

What do I think about the scalability of the solution?

The product is very scalable and can support thousands of end users. HUGE companies are using this product.

How are customer service and support?

I rate technical support with a 8-9/10. We occasionally need to escalate issues to senior technical support.

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

I was an independent consultant and have used competing products; they all have their quirks. Here at the university, we for the most part use Cognos.

How was the initial setup?

The initial setup can be complex for large organizations; for smaller companies, it is easier.

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

For the university, Cognos is very competitive, because IBM offers huge discounts to higher education. My advice would be to work with an IBM business partner.

Which other solutions did I evaluate?

Cognos was already installed here when I was hired. The university hired me for my experience.

What other advice do I have?

Hire an experienced business partner, who can provide ongoing support and training.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer2293248 - PeerSpot reviewer
Data Engineer at a financial services firm with 10,001+ employees
Real User
Top 20
The solution provides good dashboarding, reporting, and ad hoc reporting
Pros and Cons
  • "Dashboarding, reporting, and ad hoc reporting are the valuable features of IBM Cognos."
  • "There are a lot of limitations with the out-of-the-box tool."

What is our primary use case?

We use IBM Cognos to help clients with reporting.

What is most valuable?

Dashboarding, reporting, and ad hoc reporting are the valuable features of IBM Cognos.

What needs improvement?

There are a lot of limitations with the out-of-the-box tool.

For how long have I used the solution?

I have been using IBM Cognos for many years.

How are customer service and support?

We have their premier dedicated support. I rate the solution's technical support eight and a half out of ten.

How was the initial setup?

The solution's initial setup is not too bad. We have IBM support if we run into issues.

What other advice do I have?

Overall, I rate IBM Cognos an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
IBM Cognos
January 2025
Learn what your peers think about IBM Cognos. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,158 professionals have used our research since 2012.
KARTHIKEYAN THANGARASU - PeerSpot reviewer
Database Administrator at American Savings Bank
Real User
A strong reporting tool with good dashboard functionality, but lacking a configurable UI
Pros and Cons
  • "The dashboarding offered by this solution is very valuable to us."
  • "We would like to see development of the product's UI function, to make it more of a UI tool that can be configured as required."

What is our primary use case?

We use this solution to create and deploy security packages throughout the network, as well as system analysis reporting.

How has it helped my organization?

This solution has provided us with a single control tool, which allows us to easily provide reports for the different sections of our banking environment.

What is most valuable?

The dashboarding offered by this solution is very valuable to us.

We also like data module that comes with this product.

What needs improvement?

We would like to see development of the product's UI function, to make it more of a UI tool that can be configured as required.

For how long have I used the solution?

We have been using this solution for five years.

What do I think about the stability of the solution?

We have found this solution to be stable, but the products performance can be affected by the servers in use, if it is being hosted on-premises.

How was the initial setup?

The initial setup for this solution is straightforward, if the staff involved are experienced with the product. However, the deployment takes time to carry out.

What about the implementation team?

We implemented the solution using our in-house team.

What other advice do I have?

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1538121 - PeerSpot reviewer
Head of Data Architecture at a financial services firm with 10,001+ employees
Real User
Solution with plenty of valuable features and great tech support
Pros and Cons
  • "The three IBM Cognos features I find the most valuable are Dynamic Cubes, PowerPlay, and Watson."
  • "I would like to see the introduction of mapbooks for supporting some geographical information."

What is our primary use case?

Our primary use cases for IBM Cognos are operational and other reports. 

What is most valuable?

The three IBM Cognos features I find the most valuable are Dynamic Cubes, PowerPlay, and Watson. 

What needs improvement?

I would like to see the introduction of mapbooks for supporting some geographical information. IBM Cognos could be improved with some analytical solutions that could help us make predictions.

For how long have I used the solution?

I have been using IBM Cognos for five years, I think. 

What do I think about the scalability of the solution?

We have 700 individuals using the solution and plan on increasing that number. 

How are customer service and support?

I think the IBM Cognos tech support is good. 

How was the initial setup?

I don't know what the initial setup was like because I wasn't with the company at that time. 

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

I can't say much about the licensing costs because I am not privy to that information. However, I do know we are sharing a global license. 

What other advice do I have?

On a scale of one to 10, with one being the worst and 10 being the best, I would give IBM Cognos a nine for overall performance. 

Which deployment model are you using for this solution?

On-premises
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
Director at a transportation company with 10,001+ employees
Real User
Quickly generate quality reports with the ability to automate annual reports
Pros and Cons
  • "We are able to generate quality reports easily which allows us to decrease response time."
  • "I would like for the platform to become more standard. If we make a development on our report and our dashboard, it will not be used in another solution. That means there is no portability for the developers."

What is our primary use case?

I am an IT project manager. We take the commercial data of one of our operators and use this information traffic as our ticketing service. These are very traditional and static needs that are being deployed.

How has it helped my organization?

We are able to automate annual reports.

What is most valuable?

We are able to generate quality reports easily which allows us to decrease response time.

it avoids wasting time in repetitive actions such as monthly, quarterly and annual activity reports

What needs improvement?

I would like for the platform to become more standard. If we make development on our report and our dashboard, it will not be used in another solution. That means there is no portability for the developers.

It would also be nice to be able to export the dashboard. Some dashboards can be deployed and seen by everyone. But the problem is, I have to go through the Cognos server to define each user. There is no flexibility to do it as a report that can be published as a web report or something like that for many users.

What do I think about the stability of the solution?

I think the solution is stable.

How are customer service and support?

We utilized an IBM expert for support.

What about the implementation team?

Implementation was done by an expert, we did not have any issues with the setup.

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

It is pretty expensive.

Which other solutions did I evaluate?

We looked at Tableau. This tool is fast and easy to use because it uses the desktop. Tableau is better for the advanced users in my opinion.

What other advice do I have?

I think that Cognos is very efficient for the matured enterprise.

I also believe that the functions for the BI are not mature yet. I would advise asking for assistance whenever implementing a new function so that they can properly handle the configuration, adjustment, and tuning of the servers which will make it easy on you as the end user.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Data Warehouse Manager at a construction company with 10,001+ employees
Real User
The burst ability allows us to control the prompting activity and automate monthly reporting to our end users.

What is most valuable?

  • The ability to burst. It allows us to control the prompting activity and automate monthly reporting to our end users as we mass distribute to almost 900 end users.
  • The GUI design interface is intuitive.

How has it helped my organization?

  • We are able to rapidly communicate financial reporting and statements for reconciliation purposes.
  • People are able to self serve with the provided authoring tools.

What needs improvement?

  • The visualization tools have greatly improved but the active reports still need help.
  • The build process of linking the variables can be a bit complex, especially for newbies.
  • The ability to secure on the downloaded dataset that feeds the active report is prohibitive of its widespread use.

For how long have I used the solution?

We have used the solution for seven years.

How are customer service and technical support?

I would rate the technical support at about 5/10. We continue to struggle with IBM provided first or second time correct responses to cases we have open. Cases can drag on for months before resolution.

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

I am not aware of any previous solutions.

How was the initial setup?

The setup was complex. We built scripts to create and configure at a redundant server level.

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

The prodict is expensive.

Which other solutions did I evaluate?

We evaluated Oracle OBIEE and Jaspersoft.

What other advice do I have?

Investigate the cloud option for savings in maintenance and patching.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are research partners.
PeerSpot user
it_user193824 - PeerSpot reviewer
Business System Analyst at a consumer goods company with 1,001-5,000 employees
Real User
We use it for customized reports. It has features we are constantly learning how to use.

What is most valuable?

It is used for customized reports. It is the only tool supported by our IT group for user reports.

Customized reports are valuable because you can probably create any report you could imagine with it. It has features we are constantly learning how to use. It does allow the users to pull their own data, provided they are given a good framework/datasource that has been created with the options they need to use.

How has it helped my organization?

Currently, we just use it for user-requested reports. It has more features that, if we had the manpower, we could better set up the tool so users could do their own reporting. IT here are just getting around to letting users do their own reporting.

What needs improvement?

More flexibility for joining data sources within reports would be nice. It seems to be a feature IBM is slowly developing.

We have several framework/packages created. For example, we have one for sales, one for shipping, one for manufacturing, etc. You go to create a report in sales, but the one table that you need is defined in the manufacturing package. You can’t join the two packages in Cognos. Someone has to create the table on the sales package in Framework; then, it can be used in the report.

For how long have I used the solution?

I have used it for three years.

What do I think about the stability of the solution?

I have not encountered any stability issues.

What do I think about the scalability of the solution?

I have not encountered any scalability issues.

How are customer service and technical support?

We purchase support from a vendor because support from IBM is more complicated and seems to take longer. Our vendor knows us and can respond faster.

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

My company was using this software at least 10 years prior to me joining.

How was the initial setup?

I wasn’t at my company for initial setup. We have consultants do the upgrades, because they do tend to be complex and we are short on manpower.

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

It is very expensive… You have to determine if the complexity of software you are getting is worth the price you are paying; how many bells and whistles do you need for what price. And if you don’t have the manpower to implement all the features, is it worth the cost?

Which other solutions did I evaluate?

I wasn’t at my company when they chose it, but I think it might be beneficial to re-evaluate the options.

What other advice do I have?

Make sure you realize the scope of the product. It is not easily maintained by one or two people. It involves more than just Cognos for report writing; you also need to use Framework to create the data models/packages to use with it. I have done IT for 30 years; it is one of the more complex report writing tools I have used.

Also, make sure you are in it for the long haul with the costs that are associated with maintaining the software.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free IBM Cognos Report and get advice and tips from experienced pros sharing their opinions.
Updated: January 2025
Buyer's Guide
Download our free IBM Cognos Report and get advice and tips from experienced pros sharing their opinions.