Try our new research platform with insights from 80,000+ expert users

Oracle OBIEE vs SAP Crystal Reports comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th)
Oracle OBIEE
Ranking in Reporting
3rd
Average Rating
7.8
Reviews Sentiment
7.5
Number of Reviews
157
Ranking in other categories
BI (Business Intelligence) Tools (5th)
SAP Crystal Reports
Ranking in Reporting
9th
Average Rating
8.4
Number of Reviews
49
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Reporting category, the mindshare of IBM Cognos is 4.4%, down from 6.1% compared to the previous year. The mindshare of Oracle OBIEE is 4.8%, down from 6.5% compared to the previous year. The mindshare of SAP Crystal Reports is 2.8%, down from 4.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
VishnuReddy - PeerSpot reviewer
Handles large datasets and easy to interact with and handle but performance could be better
Oracle's technical support usually recommends to upgrade when you contact them for support. They don't focus on fixing the issue at hand or providing guidance on how to do it. If you are in a lower environment, like one version down, they will blindly suggest upgrading. Additional patches are given for other Oracle products like WebLogic, databases, and apps. They fix issues and create patches based on client needs. But from an OBIEE point of view, they mostly provide bundle patches of around 5 to 6 GB that need to be applied and tested end-to-end. It's not an easy way to get small patches, and if issues arise after applying the patches, you have to contact Oracle again.
MVD Prasad - PeerSpot reviewer
Helps analyze your data by creating richly formatted, pixel-perfect, and multiple reports from virtually any data source, delivered in over a dozen formats
It has significantly enhanced security features, especially when compared to the standard security features of the earlier PeerSpot version I purchased. I've observed improvements in security, and overall, it's quite commendable. Regarding potential enhancements for the next release of this solution, I haven't closely examined SAP Crystal Reports 53. I've only encountered it briefly, perhaps once or twice. However, I anticipate that it likely offers advanced features distinct from its predecessor. I believe there may be notable improvements and additions in the latest version, and I look forward to exploring them further.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"For planning, forecasting, in-boxing, modeling in general and for predicting numbers and doing work analysis, they are excellent."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"The correlation analysis is excellent. It's one of the best that I have used to date."
"Integration with Office can enable the 'download' mode of storytelling.​"
"The Report Studio that is aimed at professional report writers."
"We use the account statement report. When you use an account in HSBC, you receive various types of accounts, such as the stock market, fixed accounts, credit cards, and business accounts. We can create one consolidated report called CCS support, which includes all these accounts. In that statement, we are consolidating all those accounts."
"IBM Cognos improves the effectiveness of the sales team."
"There are some great new features in the latest version."
"The centralized metadata model component is most valuable."
"A great feature of the solution is its stability."
"It has helped to consolidate data and report on a single version of the truth."
"The most valuable feature of Oracle OBIEE is interactive reporting because it allows better analysis versus conventional reporting, especially on the data warehouse side."
"The most valuable feature is the ability to run it in Exalytics within memory coupled to a Repository on Exadata is where it flies. So it's not meant for mom and pop shops, but if you are a global 500 fortune 1000 company, this is a tool that can get you what you need on time and even in real time."
"The main features of this solution are that it is easy to use, intuitive, and user-friendly. When I retrieve the data from the database it is in a very raw form, then when I use the Oracle Report Builder it has advanced intelligence features to allow me to view and make changes to the data easily."
"It doesn't have many frills and is definitely older technology, but it is undeniably a workhorse."
"The most valuable feature of the solution is that it is a fantastic way of generating reports."
"The overall environment is the best. Data management, graphs, and layout – everything is the best, in my opinion."
"It is an user-friendly solution."
"The most valuable feature is that from a user's point of view, it is easy to use and requires just a simple click to generate a report."
"SAP Crystal Reports offers a plethora of features, many of which were available much earlier than in the Crystal Reports we previously used. We extensively use its capabilities for generating general reports, working with Kaspersky data, and even incorporating images into our reports. The range of functions available in SAP Crystal Reports is diverse, and we leverage them across various systems for our needs."
"The initial setup of the solution is pretty easy."
"I find Crystal Reports very easy to use, even for a non-technical person."
"We use SAP Crystal Reports for operational reporting."
 

Cons

"The solution seems to slow down the servers."
"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."
"They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of the product."
"The data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help."
"Cognos charts are not as fast as those of the other tools, even with DQM (dynamic query mode)."
"One key area for improvement is the need to improve the self-service nature and functionality of the product in terms of visual analytics."
"IBM Support can be slow at times, but they can usually deliver in a timely manner."
"It would be nice to offer free online training on the tool for end-users."
"One feature I would definitely like to see is the ability to provide the in-memory data. Oracle might have some plugins but, as of now, that feature isn't available out-of-the-box. You might have to purchase that feature."
"Particularly on the Cloud, a lot of functionality has yet to be ported."
"In the on-premises version, the feature for connecting and selecting the data between the databases looks a bit cumbersome, but I am not sure. The person who is using it takes a lot of time to design a data warehouse. When I ask him why is it taking this long, I get a response that this is something that he has to design, and there are different tools that are available. He has to write the ETL and design the warehouse according to the customer's requirement, which takes a lot of time. Its visualization should be enhanced, and there should be a feature where you can easily create your custom data warehouse."
"While it is a user-friendly, data-driven tool, the data modeling should be easier to use."
"The graphical capabilities could be better. They are also cumbersome, and they are limited compared to Tableau, Power BI, or even Business Objects to a certain extent and Cognos. The error logging isn't great either. The errors that come out when you schedule aren't easy to understand. I find how they filter within a query quite cumbersome and difficult to debug if somebody else has done it. You can see as you build, and I think that's where the problem is. It doesn't lend itself to debug something. For example, if you create a formula that's quite complicated, it's not easy to understand what goes with what. It becomes spaghetti, and it's very difficult to unpick. That's really my gripe about it, and in some ways, it's too flexible. It tries to be a Jack of all trades when it's not. I think a lot of these products, if they concentrate on trying to produce your reports, then that's fine. But when they're trying to do all sorts of other things as well, then it isn't very easy. We get lots of support from Oracle, but I think the problem is that we get many invalid file operations. Nobody understands why. It can be a multitude of reasons, but no one reason could cause it. That's just one of the issues we've had in the last year. But the scope of reporting has gone through the roof over the previous 12 to 18 months. We want an end-of-life OBIEE in our environment because some of the infrastructure runs unclustered. We weren't allowed to go clustered for some reason, and we never knew why. Unfortunately, going down that route means that the platform we run it on, WebLogic, has now become non-standard within our organization. Everything's been moved off it and onto other platforms. Unfortunately, our OBIEE runs on that platform, and we're being pushed down different routes, and we don't know where we're going at the moment. Within the next two years, I don't think we'll have OBIEE in our part of the business. In the next release, I think having the capability of being able to develop and then promote to a production environment rather than having to have separate environments will help. I know that Tableau and Power BI can be created on a desktop application, and then when it's ready to go live, you can promote it."
"I would like to see enhancements in tracking, debugging, and flexibility."
"Implementation is cumbersome and requires expertise."
"In our organization, we feel that data visualization for APIs is an area in which the solution lacks."
"The financing part needs improvement."
"If at all possible, a little bit of improvement on the analytical side is needed."
"SAP Crystal Reports should provide better support for dynamic connectors."
"It has significantly enhanced security features, especially when compared to the standard security features of the earlier PeerSpot version I purchased. I've observed improvements in security, and overall, it's quite commendable. Regarding potential enhancements for the next release of this solution, I haven't closely examined SAP Crystal Reports 53. I've only encountered it briefly, perhaps once or twice. However, I anticipate that it likely offers advanced features distinct from its predecessor. I believe there may be notable improvements and additions in the latest version, and I look forward to exploring them further."
"There could be improvements made to the analytics capabilities."
"SAP Crystal Reports has some compatibility issues with third-party products."
"Maybe some Power BI-related features could be added, like dashboards or direct editing in reports."
"A real improvement would be a simpler system that allows users to play with the visualization without needing specialized skills and code."
 

Pricing and Cost Advice

"Pricing should be improved."
"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
"The pricing and licensing policies are comparatively cheaper than other products in the market ."
"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"On a scale from one to ten where one is low pricing and ten is high pricing, I would rate this solution at eight."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"Oracle products are extremely expensive."
"I would rate it a 4 out of 5 in terms of pricing."
"It is an expensive solution."
"The licensing cost is based on the number of users using it."
"A person only needs to pay towards the subscription costs since it is a cloud-based solution. I use the free version of Oracle OBIEE."
"The price of Oracle OBIEE is expensive, it is difficult for a small business to afford."
"The pricing we negotiated with Oracle. But, I do not have details."
"Simplifying the data integration process would save our clients considerable costs."
"This product costs a lot of money."
"SAP Crystal Reports is a very expensive solution."
"We pay fifteen hundred dollars as licensing fee."
"The cost of licensing can be a significant factor to consider when upgrading or transitioning to a new version of SAP Crystal Reports. It's important to evaluate the benefits and features offered by the new version against the associated costs to ensure it aligns with your organization's needs and budget."
"I feel that SAP Crystal Reports is a reasonably priced product."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Educational Organization
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Financial Services Firm
17%
Government
13%
Computer Software Company
11%
Manufacturing Company
8%
Computer Software Company
11%
Financial Services Firm
10%
Government
10%
Manufacturing Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are ...
Which Oracle product is better - OBIEE or Analytics Cloud?
Oracle OBIEE is designed to be relatively easy to set up and has a helpful customer support staff at the ready to ass...
What do you like most about Oracle OBIEE?
The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI f...
What needs improvement with SAP Crystal Reports?
Maybe some Power BI-related features could be added, like dashboards or direct editing in reports. We use query langu...
What is your primary use case for SAP Crystal Reports?
We use SAP Crystal Reports for reporting. We use it for financial reports like statements of accounts, trial balances...
What do you like most about SAP Crystal Reports?
We use SAP Crystal Reports for operational reporting.
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
No data available
 

Learn More

 

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
City of Buenos Aires, ASR Group, Citrix, EarlySense, Usha International Limited, Automotive Resources International (ARI), LivePerson, Coelba (Grupo Neoenergia), RZD Russian Railways, National Basketball Association - NBA, TALLY WEiJL, El Machetazo, Young Heroes, Mozzart, Mitsui Knowledge Industry (MKI) , Surgutneftegas Open Joint Stock Company, The VELUX Group, AOK Bundesverband, AL-KO KOBER GROUP
Find out what your peers are saying about Oracle OBIEE vs. SAP Crystal Reports and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.