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

SAP BW4HANA pros and cons

Vendor: SAP

3.8 out of 5

42 reviews
86% willing to recommend

102 followers

Pros & Cons summary

SAP BW4HANA offers robust performance with real-time data integration via HANA, aiding financial and material management. It integrates seamlessly with SAP ERP, providing pre-defined content suitable for DW implementations. While it's scalable and easy to maintain, integration with other tools is challenging. Setup, data migration, and pricing issues exist. Real-time analytics may not match other products, but it supports granular customization for less technical users.

Buyer's Guide

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

Prominent pros & cons

PROS

SAP BW4HANA is recognized for its robust performance and stability.

The integration with SAP ERP and HANA database enhances its real-time data capabilities.

It offers extensive scalability, making it suitable for growing business needs.

SAP BW4HANA provides comprehensive reporting and analytics capabilities, improving financial and material management functions.

The tool's ability to handle complex data transformations and customization is highly valued, allowing flexible data modeling.

CONS

SAP BW4HANA struggles with integration, especially with third-party tools, which limits its functionality.

It is complex and requires a significant amount of learning, making implementation challenging.

Pricing is considered high and technical support is expensive, leading to dissatisfaction among users.

There is a need for improvement in query optimization and guided tools to help users navigate issues effectively.

Connectivity and integration challenges exist, particularly with keeping up with real-time client requirements and legacy systems.

SAP BW4HANA Pros review quotes

Srivatsav Andra

SAP BW/4HANA Specialist at a government with 10,001+ employees

Apr 9, 2023

You can do hierarchical alert slicing and dicing out-of-box, which is not available in other solutions. I haven't come across that in Oracle or any other software provider.

Read full review

Co-founder & Partner at idiligence Solution

Feb 14, 2024

It is a stable solution...It is a scalable solution.

Read full review

reviewer1426734

Head of Enterprise Reporting & Analytics at a manufacturing company with 10,001+ employees

Jan 7, 2021

Its direct approach is the most valuable. You get more real time and capabilities than BW.

Read full review

Free Report: SAP BW4HANA Reviews and More

Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

824,053 professionals have used our research since 2012.

Director Sales at Rialtes

Apr 2, 2024

It is a very stable solution.

Read full review

PN

BI Manager at a manufacturing company with 1,001-5,000 employees

Jul 31, 2019

The most valuable feature is that it's robust.

Read full review

Manager, Business Analytics, BI Lead at Capgemini

Jul 4, 2024

It provides the functions in a way that even a less technical person can do the modeling.

Read full review

FranciscoSantos

Director at Pixel Studio PTY

Aug 5, 2019

The processes are the most valuable aspect of this solution.

Read full review

Anandha Krishna

Senior Architect at iQM

Apr 17, 2024

One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless access to real-time analytics. Additionally, it enables real-time data integration. We don't need to rely on historical data alone; we can provide reporting and features based on real-time information.

Read full review

Csaba Grünblatt

Senior Data, Data warehouse and BI/Analytics Architect at Techwave.

Mar 25, 2024

I like how it blends no-code and ABAP code for complex transformations during data loading.

Read full review

SA

Lead Consultant at Infosys Technologies Ltd

Feb 2, 2020

Out of the box, this solution has a lot of standard features.

Read full review

Show 10 more reviews (out of 41)

SAP BW4HANA Cons review quotes

Srivatsav Andra

SAP BW/4HANA Specialist at a government with 10,001+ employees

Apr 9, 2023

There's one area where the other vendors have an upper edge, which is the data lake. I think SAP is trying to figure out whether to stick with IQ, their own data lake solution, or push customers toward customer-preferred vendors, like Azure Data Lake, AWS, or any other provider.

Read full review

Co-founder & Partner at idiligence Solution

Feb 14, 2024

The cost of the product might be an area that might introduce some restrictions or limitations to customers, making it one of the aspects where improvements are required.

Read full review

reviewer1426734

Head of Enterprise Reporting & Analytics at a manufacturing company with 10,001+ employees

Jan 7, 2021

They have taken out a few BW functionalities when they redesigned this. The way of multi-dimensional thinking and star schema got a little bit lost. It may be because of the cost, but certain functionalities that were previously implemented from the BW side should come back again in the whole product. It is a young product. It is version 2.0. In time, I'm pretty sure they will come back again because otherwise, it limits the potential of the product, and I have to do a lot of modeling towards that direction. For me, the analytics focus is too much. It is not cube-oriented in that way, so its functionality is limited. It is not really technically limited in the back end; it is more limited in the front end. It has a data-mining mindset for SQL developers. The navigational attributes should be easy. It needs to be built in models. I see the data mark cube or understanding that the composite provider needs to be models in a cube coming back. The multi-dimensional star schema approach and the reporting need to be done as well as possible to leverage the star scheme below. This is definitely not understood by many consultants and even composite providers for star schema. They always think in terms of flat tables, which is limiting. You need to build the right dimensions, objects, and so on. If you can build this in BW4HANA, then you have this understanding that BW4HANA is not forcing you in this direction, but it should force you a bit better in this direction. Maybe a few elements which were in use in BW should come back again. It would help the community to determine the direction to build on the cube. You can have maybe 50 elements, and then you can expand it to what you need by leveraging navigation. So far, this functionality is a little bit limited in the tool, and it is not thought through, but I think it will come. They should also be adding more capabilities for the transformation between different objects. In BW, this is currently limited, especially towards composite providers. It is a bit complex basically in the building. You have to have a lot of knowledge as well as know how to do it better because it is a bit different from BW. There is not too much expertise currently in the consulting markets. Many are trying to build something, but it may be based on their knowledge of what they have from the BW and HANA side. You have to find the right mix from both of them at this time. We also have HANA Native. These are our two different sync sources basically, and we have approaches to connect nicely, but it is hard to manage your team because a lot of coaching is required.

Read full review

Free Report: SAP BW4HANA Reviews and More

Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

824,053 professionals have used our research since 2012.

Director Sales at Rialtes

Apr 2, 2024

I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated.

Read full review

Manager, Business Analytics, BI Lead at Capgemini

Jul 4, 2024

Real-time processing isn't BW/4HANA's strongest point.

Read full review

PN

BI Manager at a manufacturing company with 1,001-5,000 employees

Jul 31, 2019

I cannot integrate it with my other tools. It's not possible to do something in the predictive analysis. Mobile reporting is also not available.

Read full review

Anandha Krishna

Senior Architect at iQM

Apr 17, 2024

There's the complexity in migration from BW to BW/4HANA, especially with data migration.

Read full review

Csaba Grünblatt

Senior Data, Data warehouse and BI/Analytics Architect at Techwave.

Mar 25, 2024

One thing that could be enhanced in SAP BW4HANA is the user interface for process chains.

Read full review

SA

Lead Consultant at Infosys Technologies Ltd

Feb 2, 2020

Connecting multiple sources is a challenge because you have to go through a lot of different setups.

Read full review

Shaik Abdul Khadar

Chief Executive Officer at a tech services company with 11-50 employees

Aug 20, 2024

The problem is the expensive pricing of technical support, making it an area where improvements are required.

Read full review

Show 10 more reviews (out of 40)

Product Categories

Product Categories

Popular Comparisons

Popular Comparisons

Snowflake vs SAP BW4HANA

Teradata vs SAP BW4HANA

Oracle Exadata vs SAP BW4HANA

Vertica vs SAP BW4HANA

VMware Tanzu Data Solutions vs SAP BW4HANA

Apache Hadoop vs SAP BW4HANA

Oracle Database Appliance vs SAP BW4HANA

IBM Db2 Warehouse vs SAP BW4HANA

SAP IQ vs SAP BW4HANA

Microsoft Parallel Data Warehouse vs SAP BW4HANA

SAP NetWeaver Business Warehouse vs SAP BW4HANA

See all alternatives

Product Categories

Product Categories

Popular Comparisons

Popular Comparisons

Snowflake vs SAP BW4HANA

Teradata vs SAP BW4HANA

Oracle Exadata vs SAP BW4HANA

Vertica vs SAP BW4HANA

VMware Tanzu Data Solutions vs SAP BW4HANA

Apache Hadoop vs SAP BW4HANA

Oracle Database Appliance vs SAP BW4HANA

IBM Db2 Warehouse vs SAP BW4HANA

SAP IQ vs SAP BW4HANA

Microsoft Parallel Data Warehouse vs SAP BW4HANA

SAP NetWeaver Business Warehouse vs SAP BW4HANA

See all alternatives

Related questions

36

SAP BW4HANA vs Microsoft SQL Server: are they comparable?

32

How do I extract SAP BW data models and SAP HANA data models?

11

Which do you prefer: SAP BW/4HANA on the cloud or SAP BW on Azure?

227

Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza

59

When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?

20

At what point does a business typically invest in building a data warehouse?

101

Is a data warehouse the best option to consolidate data into one location?

112

What are the main differences between Data Lake and Data Warehouse?

18

Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?

38

What is the best data warehouse tool?