it_user560289 - PeerSpot reviewer
Cognos Consultant (Contract) at a university with 1,001-5,000 employees
Vendor
Allows me to control how my reports look and behave.

What is most valuable?

Various studios vary in the level of control they give you in putting together a report. As an example, I spend most of my development time in Report Studio. I have always been impressed by the level of control I have in how my reports look, behave, and allow interaction.

How has it helped my organization?

  • Allowed the organizations I've worked for to standardize the information they deliver to hundreds of decision makers.
  • Allowed insight into the operations and trends of the business with speed and accuracy.
  • The toolset allows you to create a framework to deliver a range of BI solutions. These scale from high level strategic dashboards with key performance indicators to tactical and operational reporting for the day-to-day running of business activities.

What needs improvement?

Metadata documentation could be improved. While IBM Cognos tools allow you to document most aspects of the metadata layer, the way this information is stored and exposed for metadata management is too basic.

For how long have I used the solution?

I have been using IBM Cognos for 17 years.

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

What do I think about the stability of the solution?

I have had no issues at all with stability. Cognos is one of the most robust products out there.

What do I think about the scalability of the solution?

There are no issues with scaling this product to a large number of users. The technical architecture is such that scaling is handled easily.

How are customer service and support?

Most technical support issues that I had were revolved in a prompt manner. The amount of information on the IBM knowledge base is impressive. The user community online is full of some brilliant ideas and solutions that I have used many times.

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

Most companies that I have consulted for had IBM Cognos in place for several years.

How was the initial setup?

A lot of companies that I've worked with outsource the set up activity to IBM or a second-tier consulting firm.

In every case, it has proven to be a wise move. I've never seen the choice of machines or configurations become an issue later down the track.

My advice is to outsource what you are not in the business of doing every day.

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

Do your homework on the licensing that you require. The penalties and costs involved if you are audited for licensing can be expensive.

IBM does not allow you to trade or swap licenses. Most companies don't allow this either. The definitions of what each license holder is and requires should be clearly understood before entering into any agreements.

Some of their requirements around user licensing for those who were only consumers of reports (e.g., they have output sent to them by email) used to be fairly onerous.

Which other solutions did I evaluate?

When I've been involved with a software selection, the contenders were BusinessObjects, Cognos, and Oracle. Cognos won due to its broad coverage of features and solutions that it covers as well as the product maturity.

What other advice do I have?

  • Resourcing: Don't underestimate the resources required to build good business intelligence reporting and analytics. For example, if you skimp on training, you'll have a great tool set that is going to be used poorly by its user community. Businesses implementing IBM Cognos need to get the balance right in terms of who carries out what activity, especially who and where report authoring takes place. One of the companies I've consulted for gave little training to people in the business outside of IT. As a result, poor quality and slow executing reports were the result.
  • Culture: Use these tools to promote the right culture. A lot of the benefit of using IBM Cognos will depend on your organization's maturity level with regards to its use and implementation of these tools and how you integrate their usage into your business processes and decision making. The culture has to be present to allow any BI tool to be successful.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user544740 - PeerSpot reviewer
Senior Business Intelligence consultant, freelance at a tech consulting company with 51-200 employees
Consultant
It provides us with a wide range of professional report types through the central report designer tool, Report Studio.

What is most valuable?

The most valuable feature is scalability. It works perfectly for companies from 100 users to companies with several thousand users.

How has it helped my organization?

It provides us with a wide range of professional report types through the central report designer tool, Report Studio. Standard reports, used through the whole international organization, have been made with user security to personalize the report output.

What needs improvement?

The Cognos BI suite is missing a user-friendly tool/functionality that makes it possible for regular BI users (not report developers) to make personalized reports. Generally, Cognos is not easy to use for non-experienced BI users who need to make their own reports.

For how long have I used the solution?

We have been using this product for ten years.

What do I think about the stability of the solution?

There have been no stability issues. If the installation was done properly, it is a stable system.

What do I think about the scalability of the solution?

There have been no scalability issues. The product is perfectly designed for smaller companies to multi-national companies. The server architecture must be designed accordingly, but it's easy to upscale by adding servers.

How are customer service and technical support?

Technical support is good. The IBM Cognos support is usually dedicated and competent. Their reaction time is fast enough according to the support case priority.

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

I have worked in migration projects from BusinessObjects to Cognos, as the customer had bought a global IBM solution.

How was the initial setup?

The initial Cognos setup requires experienced people. Besides a correct software installation on a multi-server architecture, it is important to design an adapted Framework Manager architecture. Furthermore, it requires experience to make some professional standard reports or other advanced reports, such as Active Reports.

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

Licensing is expensive and can be an issue to expand the number of users within a company or to get new customers. Only large companies invest in Cognos.

Cognos is not a very common BI product in Denmark, even though it's one of the best on the market with a broad palette of tools.

More creative licensing policies should be made by IBM in order to win market shares in the BI market.

What other advice do I have?

Employ some experts with a lot of experience, or hire consultants with documented experience if it's difficult to recruit.

Be sure to give the right training to the developers/advanced users at the right time. In other words, don’t do it too early in the implementation phase before the product is used within the organization.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
IBM Cognos
May 2024
Learn what your peers think about IBM Cognos. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
771,170 professionals have used our research since 2012.
PeerSpot user
Senior Development Manager - Innovation - ERP Protheus with 1,001-5,000 employees
Vendor
ETL support is important to our clients with big data. You must have technical skills to build reports.

What is most valuable?

  • ETL
  • A lot of features
  • Performance

These are important to big clients with big data.

How has it helped my organization?

For our clients, this product helps them make decisions faster, based on high-quality data.

What needs improvement?

The new version’s web interface isn't easy to use by 'regular' users. You must have technical skills to build reports. The product is not like QlikView or Tableau, where 'regular' users can build their reports on their own.

For how long have I used the solution?

I have used it for four years.

What do I think about the stability of the solution?

I have encountered a few 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?

Technical support is good.

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

I did not previously use a different solution.

How was the initial setup?

Initial setup was complex; many servers.

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

It is expensive.

Which other solutions did I evaluate?

Before choosing this product, we evaluated MicroStrategy and SQL Analysis Services.

What other advice do I have?

You need an IT team to support the users. It is not a BI-as-a-service app.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an IBM partner.
PeerSpot user
it_user174690 - PeerSpot reviewer
BI Senior Consultant at a computer software company with 51-200 employees
Vendor
Framework Manager is the best Metadata Modeling Tool but we have to restart the mobile server everyday

What is most valuable?

Framework Manager.

How has it helped my organization?

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

For how long have I used the solution?

4 years.

What was my experience with deployment of the solution?

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

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

No I did not.

How are customer service and technical support?

Customer Service:

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

Technical Support:

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.

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

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.

How was the initial setup?

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

What about the implementation team?

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

Which other solutions did I evaluate?

We compared products with Gartner Reports.

What other advice do I have?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user175269 - PeerSpot reviewer
it_user175269Owner at a tech services company
Consultant

I meant hard-to-manage in the sense of the need to develop a multitude of cubes in order to perform analysis. When using cubes for analysis I use an analogy to my time in the Army when directed to a location that was off the map sheet (pre-GPS). When that happens, it's back to the IT shop to have a new cube created. This is much more minor issue with MicroStrategy and its ROLAP architecture. Combine that with MicroStrategy's single metadata, focus on analytical empowerment of the user (rather than dedicated designers), create once, use anywhere (desktop, web, mobile) with true browser-based development and editing, and MicroStrategy is a much better analytical environment. I've been a life-long information analyst with experience in MIS/DSS/EIS and for nearly 20 years in BI environments so I'm pretty familiar with many tools and their pros and cons.

See all 3 comments
it_user171960 - PeerSpot reviewer
Assistant Manager - Technology at a comms service provider with 501-1,000 employees
Vendor
Go for it but get training first

What is most valuable?

The Reports and Query Studio functions have been very valuable.

How has it helped my organization?

It enables me to see trends of data we have from different angles and each end-user can run ad-hoc queries themselves.

What needs improvement?

Framework Manager, Map Manager, and Reporting Database Connectivity features should all be free.

For how long have I used the solution?

3 years including previous version

What was my experience with deployment of the solution?

I was unable to use oracle 64 bit client to connect with oracle 64 bit databases. However, because of Linux I had to use 32 bit anyway.

What do I think about the stability of the solution?

Not much

What do I think about the scalability of the solution?

We had some minor issues with scalability.

How are customer service and technical support?

Customer Service:

7-8 out of 10

Technical Support:

8 out of 10

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

We changed because of the offer of more features and technical support than our previous solution.

How was the initial setup?

For us it was complex to do it for the first time and too much R&D had to be done. Later on it was easier. It may have been complex as it was our first time setting up the Cognos.

What about the implementation team?

Implementation was done by an In-house team who learned from scratch.

What was our ROI?

Good. It helped the purpose for which we used it.

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

I have little knowledge of this but I think we pay for each report we deploy

Which other solutions did I evaluate?

We looked at three other solutions, Netezia, Xplore, and Netcool.

What other advice do I have?

Go for it but it will require training.

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

Note that effective of 10.2.2 Query Studio and Analysis Studio have been marked for "deprecation", meaning they will not be in future releases, but would be supported for a number of years in line with IBM's usual support policies.

Workspace Advanced (for authoring) and Workspace (for consumption) are the replacements, and have been around for a number of years now.

Report Studio for professional IT authors continues to be a key component..

it_user3372 - PeerSpot reviewer
Senior Manager of IT at a government with 1,001-5,000 employees
Vendor
Provides us with "a single version of the truth."

Human Resources Management (HRM) plays an essential role in developing a company's strategy as well as handling the employee-centered activities and the strategic management of the employees, who individually and collectively contribute to the achievement of the strategic objectives of the
organization.

IBM Cognos is a flexible, database-driven Human Resources Management, forecasting and project planning tool, which is fully integrated with all core IBM Enterprise Resource Planning (ERP) modules - replacing the use of multiple, diverse, unlinked spreadsheets.

Cognos provides invaluable support for all participants in the HR and project planning cycles, of even the largest, most complex or fast-changing businesses. It supports a rich Web enabled planning and modeling framework that supports driver based planning to help connect HR assumptions to operational outcomes.

I’ve used Cognos for more than 10 years, from multiple global locations and platforms and it has allowed me to bring together information from across the organization and key systems to provide a "single version of the truth", from which to plan and make decisions. For example, it:

• Provides the core platform services of centerpiece capabilities (Talent Profiles, Employee Records, Competencies, Job Profiles, and Reports) enables planning departments to create forecasts and perform "what-if" analysis

• With Cognos’s combination of self-service facilities (allowing access from disparate locations) and workflow (to tightly control the data flow into the budgeting process), you can easily move from centralized to devolved project planning.

Cognos automatically generates supporting transactions that contains all employee records, giving you easy access to the information you need to reduce errors, enforce policies consistently, and build your business, to support more complete day-to-day operational reporting. So, for instance, a management entry may trigger an automatic compensation entry, which gives rise to changes in the employee's future compensation and reward decisions.

Cognos can integrate data: from existing spreadsheets (thanks to dynamic links into Excel); from external programs; or from end users (via user-defined, web-based input screens). This enables several business divisions or data sources to contribute to the planning and forecasting process, while keeping track of the changes and control over all the data inputs.

Sharing core ERP system administration and security infrastructure ensures that Cognos user permissions, audit controls, validation and security features are tightly managed and consistent throughout.

• Controlled user access, even when data is entered via Excel, to ensure accuracy and security of the underlying database. Complete audit trail for all data changes, user name and time of the change.

• Ultimately, IBM’s Cognos Enterprise offers a unique architecture, which delivers true "Post- Implementation Agility", allows changes to your system long after initial installation - in response to changing requirements, and without depending on expensive external consultants or constrained IT resources. This makes Cognos the ideal choice for service-based organizations that are affected by frequent and dynamic business change.

Underpinned by IBM technology, Cognos is the only planning tool that can efficiently adapt to major business change without re-implementation. You can start with native integrations from HR Management to other core talent management processes in order to support a holistic, end-to-end cloud talent management strategy.

IBM Cognos Enterprise Software offers customers the industry’s most flexible delivery and deployment options, including IBM smarter cloud solutions.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
BI Cognos Expert at Pilmark LTD
Real User
Improves sales team effectiveness for an excellent value
Pros and Cons
  • "IBM Cognos improves the effectiveness of the sales team."
  • "In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful. I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring."

What is our primary use case?

My primary use case for IBM Cognos is reporting.

How has it helped my organization?

I work with a few organizations. IBM Cognos improves the effectiveness of the sales team. For example, we know which offers work and which offers don't. We've got a very good record of that. We have the very good ability to check the meetings of the actual salespeople. When they are made, who is in them, how effective the meetings were compared to what we estimated. It's very, very good on that level.

Additionally, the budget control is very good. We get triggers once a budget is crossed. It creates and sends an email to the person who needs to know, "Hey, you're in trouble. Basically, you've crossed the line." Which a lot of times you don't realize. You have a team of 20 people and the manager gets an email if somebody has done something or there's a problem, and it gives them a very strong awareness.

What is most valuable?

IBM Cognos' feature that I have found most valuable is its ability to create very complex reports which are not available in other tools.

What needs improvement?

In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful.

I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring.

For how long have I used the solution?

I have been implementing IBM Cognos for over 20 years.

What do I think about the stability of the solution?

I think they're very stable.

What do I think about the scalability of the solution?

IBM Cognos is the most scalable option, I think. It can handle thousands of users at the same time. If anything, the only thing you need is hardware that can support it.

This product is usually focused on medium to large organizations.

How are customer service and technical support?

I'm really satisfied with the technical support. We encountered a couple of very unique bugs and IBM was very helpful. People from IBM found a quick workaround and then they solved the problem. So I'm very happy with it.

How was the initial setup?

The initial setup usually takes a few hours.

What about the implementation team?

You need a consultant or an integrator for setup. You need somebody to do it. You can't just do it by yourself.

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

In terms of pricing, for what you get, it's a relatively good price. It's good value for what you pay for. But you always want things for cheaper, but the price for what you get is relatively good, because everything is included. Everything, all the extra features that with other products you have to pay for, here they are just included. It's in it. You don't have to pay for sending out emails, you don't need to have an extra mail server. It's in the product.

What other advice do I have?

On a scale of one to ten I would give IBM Cognos a nine.

I would suggest to potential customers that if they don't have experience, there is a lot of information on the web. There are wonderful video clips in YouTube. There are wonderful blogs. Before you decide on a solution, check. There might be something that's even better than what you thought initially. The abilities are so wide and amazing that a lot of times people take a solution which is not the best, because they do what they know and they don't think, "Hey, I can do something much better."

Make sure you know all the options before you choose one. And again, reconsider. If you checked it three or four versions ago, then check again. There are new features all the time that are changing and improving, and you can get amazing results.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
BI Engineer at a media company with 1,001-5,000 employees
Vendor
Gave our organisation more insight in its data, and also in the gaps which were there (and still are).

What is most valuable?

The jobstreams and the ways SQL-scripts can be effectively organized behind icons.

How has it helped my organization?

  • It gave the organization a better insight in the quality of the data, which in many ways was poor.
  • It gave the call center the possibility to monitor its effectiveness and efficiency a lot better.

What needs improvement?

  • The Cognos Data Manager is very datamart/Kimball oriented, and it should be made more flexible, so that it can be used for architectures like Inmon’s or a data vault.
  • Some of its components are not very stable (for instance the lookups).
  • The prescribed working order (dimensions and hierarchies, then fact-tables) makes implementing design adaptations a complex and risky operation: loosen one thread, and a lot more go with it, and this should me made more flexible.

For how long have I used the solution?

I've used it roughly for more than a year.

What do I think about the stability of the solution?

The stability of the Cognos Data Manager is quite good. It doesn’t crash very often, but of course making daily backups of your work is a wise thing to do, as with any tool.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

We only had a company provide digital training. Their communication was poor, and they worked with a call center which was totally uneffective.

Technical Support:

I had to make do with what could be found on websites and the internet. The information IBM gives here is solid, but very technical and hard to read. Other websites have to be handled with care as many contributions are more enthusiastic then useful.

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

I started using Cognos Data Manager because the company I worked for already used it.

To start with SSIS:

  • SSIS is a lot more flexible than the Cognos Data Manager. In the latter, the user is pushed into the direction of a Kimball datamart architecture (data marts, which in a later stage are to be integrated into a integrated solution). SSIS leaves a lot more room to the user to make his or her own decisions (and suffer the consequences of these)
  • The user interface is a lot more user friendly in SSIS, while Cognos Data Manager is somewhat outdated (but can in capable hands still be used very effectively)

In comparison with large scripts in Oracle and SQL Server:

  • The Cognos Data Manager provides a comparison of large scripts for a real and substantial improvement. The icons and jobstreams provide a lot of structure, and are a lot easier to read and interpret than large scripts which can be hundreds of pages long
  • Functions like lookups are very nice, but not always enterily stable (which is a serious drawback in their use)
  • Combining Oracle and SQL Server databases with each other is a definite strong point of the Cognos Data Manager (although no longer a unique selling point)
  • The SQL-scripts are pasted behind the icons. It makes tracing errors and the logic of processes a lot easier

What about the implementation team?

It had already been installed, and I got a lot of support from other people in the company. I have no experience with a vendor team.

What was our ROI?

The company I worked for got a better understanding of its poor data quality, and many inefficiences in its operations. But in their mindset, speed is everything, and precision is often regarded as something of a luxury. They got more insights, made a lot of noise about it, but made no structural efforts for improvement.

What other advice do I have?

  • Consider carefully if you want a Kimball architecture with datamarts for your datawarehouse. If so, the Cognos Data Manager is a good option. If not, I think you should reconsider
  • Consider what exactly you want to achieve with your datawarehouse. For having a historical database, it can be quite effective. For daily control, in most cases a datawarehouse architecture is unsuitable and unwieldy. Direct reports on source systems are than a better option
  • If your organisation has issues with data qualities, a datawarehouse won’t solve these. It can only make these visible (and there are probably a lot of cheaper ways to do that)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user

Hi Joop

I agree, Data Manager is now dated because there hasn't been significant R&D investment in a while. It was tagged for "end-of-life" some years ago.

I liked that it modeled "the world" in terms of dimensions and facts, unlike most ETL tools, which just think of tables and you get to decide what is a fact or a dimension. There are good things and bad about this approach, which I think you referred to briefly, but on balance I think it was a major strength.

Mike

See all 3 comments
Buyer's Guide
Download our free IBM Cognos Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2024
Buyer's Guide
Download our free IBM Cognos Report and get advice and tips from experienced pros sharing their opinions.