Try our new research platform with insights from 80,000+ expert users
SAP Business Warehouse Logo

SAP Business Warehouse pros and cons

Vendor: SAP
3.9 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

SAP Business Warehouse offers rapid response times for queries related to prices, buyers, customers, providers, and services.
The integration with SAP ERP and its ability to connect to Excel for data extraction and analysis are highly valued features.
The advanced structuring and transformation capabilities allow users to extract raw data and store it in a format conducive for easy reporting.
SAP Business Warehouse is a scalable and stable platform, further enhanced by its hybrid functionality with HANA.
Its features for alerting and monitoring, especially when integrated with SAP Solution Manager, provide seamless operations with real-time information.

CONS

SAP Business Warehouse faces challenges in providing seamless connectivity with other databases and offers limited integration with Microsoft Office beyond Excel.
Technical support for SAP Business Warehouse is unsatisfactory, with representatives lacking adequate knowledge.
SAP Business Warehouse is not flexible enough with data structures, making it difficult to improve performance when designing solutions.
Generating reports in SAP Business Warehouse is time-consuming, affecting overall performance and efficiency.
Integration with ETL tools in SAP Business Warehouse is complicated and not straightforward.
 

SAP Business Warehouse Pros review quotes

CW
Chief of Systems Development at a non-tech company with 10,001+ employees
Apr 29, 2018
The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us.
reviewer1213002 - PeerSpot reviewer
IT Controlling Specialist at a pharma/biotech company with 10,001+ employees
Oct 21, 2019
The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs.
reviewer1240269 - PeerSpot reviewer
Head of BI and Analytics at a comms service provider with 1,001-5,000 employees
Nov 28, 2019
The warehouse is the solution's most valuable feature.
Learn what your peers think about SAP Business Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,078 professionals have used our research since 2012.
SC
IT Manager at GIC Re
Jan 26, 2020
The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own.
reviewer1261707 - PeerSpot reviewer
Group IT Manager at a engineering company with 1,001-5,000 employees
Feb 5, 2020
Having the back-end data set with the right information is the best qualification for this solution.
ROMIL SHAH - PeerSpot reviewer
Deputy General Manger - Information Technology at Nayara Energy
Feb 16, 2020
The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice.
reviewer1278519 - PeerSpot reviewer
SAP BusinessObjects Consultant at a tech company with 10,001+ employees
Feb 20, 2020
In terms of stability, comparatively, the solution is quite stable.
reviewer1671264 - PeerSpot reviewer
Founder & CEO at a tech services company with 51-200 employees
Sep 17, 2021
I like that it integrates to open-source.
HB
Owner / Consultant at Brodbeck
Dec 8, 2021
The most valuable aspect of the solution is the integration with SAP ERP.
reviewer1372197 - PeerSpot reviewer
Engineer( IT) at a energy/utilities company with 10,001+ employees
Dec 28, 2021
With the technical support, the response has been pretty good from the SAP side.
 

SAP Business Warehouse Cons review quotes

CW
Chief of Systems Development at a non-tech company with 10,001+ employees
Apr 29, 2018
One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection.
reviewer1213002 - PeerSpot reviewer
IT Controlling Specialist at a pharma/biotech company with 10,001+ employees
Oct 21, 2019
The advanced structuring can be complicated and the interface is not very intuitive.
reviewer1240269 - PeerSpot reviewer
Head of BI and Analytics at a comms service provider with 1,001-5,000 employees
Nov 28, 2019
The solution could offer better connectivity with other databases.
Learn what your peers think about SAP Business Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,078 professionals have used our research since 2012.
SC
IT Manager at GIC Re
Jan 26, 2020
More integration with Microsoft Office products (not just Excel) would be helpful.
reviewer1261707 - PeerSpot reviewer
Group IT Manager at a engineering company with 1,001-5,000 employees
Feb 5, 2020
I would like to see a different end solution in order to read the data and attract internal users.
ROMIL SHAH - PeerSpot reviewer
Deputy General Manger - Information Technology at Nayara Energy
Feb 16, 2020
A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution.
reviewer1278519 - PeerSpot reviewer
SAP BusinessObjects Consultant at a tech company with 10,001+ employees
Feb 20, 2020
We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least.
reviewer1671264 - PeerSpot reviewer
Founder & CEO at a tech services company with 51-200 employees
Sep 17, 2021
SAP Business Warehouse could integrate better with other ETL tools.
HB
Owner / Consultant at Brodbeck
Dec 8, 2021
It's a product that is at the end of life so they will not improve it anymore.
reviewer1372197 - PeerSpot reviewer
Engineer( IT) at a energy/utilities company with 10,001+ employees
Dec 28, 2021
In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed.