It's mainly used for finance. We use it for reporting.
Easily connects with the SAP ERP system but is complex to set up and increases development time
Pros and Cons
- "We like that it is an SAP product, so we can easily connect with the SAP ERP system."
- "If I want to have good reporting, then I have to buy a separate license."
What is our primary use case?
How has it helped my organization?
We use SAP standard functionality to get the data from SAP and then just report on it. It's pretty fast.
What is most valuable?
We like that it is an SAP product, so we can easily connect with the SAP ERP system.
Support is okay.
I've found the product to be scalable.
The solution is stable.
What needs improvement?
It has a lot of problems in terms of technical architecture. If I change something in BW, a lot of development becomes inactive.
The development time for any developer is quite huge compared to other products.
The setup is a bit complex.
If I want to have good reporting, then I have to buy a separate license. I have to pay for separate things. That's quite irritating.
Buyer's Guide
SAP BW4HANA
December 2025
Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,768 professionals have used our research since 2012.
For how long have I used the solution?
I've been working with the solution for 16 years.
What do I think about the stability of the solution?
It is stable. It's reliable and doesn't have bugs or glitches.
What do I think about the scalability of the solution?
We can scale the solution if we need to.
There are about 150 people on the solution.
How are customer service and support?
Technical support is okay. The turnaround time is quite high. they are a bit slow.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
I've used other solutions as well, such as Qlik and PowerVM.
They are pretty fast in terms of performance, so the ease of development is extremely good. My turnaround time for the business was less.
How was the initial setup?
The initial setup is not straightforward. SAP is not at all straightforward during implementation.
It is not difficult to maintain.
What about the implementation team?
We handled the initial setup in-house with the help of a third party.
What was our ROI?
We have achieved an ROI.
What's my experience with pricing, setup cost, and licensing?
The cost is average. I'd rate it five out of ten in terms of the affordability of the standard license.
What other advice do I have?
I would advise, that if you have SA, as in ERP systems, the BW is fine. If you do not have SAP ERP, for example, if you have a non-SAP system from where you want to load the data, then SAP BW is not a good solution. It will increase the turnaround time.
I'd rate the solution three out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
SAP BPC Consultant at a tech services company with 10,001+ employees
UI is completely new, beautiful, and user-friendly
Pros and Cons
- "The UI is completely new, beautiful, and user-friendly. There are some other helpful features like global filters and advanced tools. We can perform custom calculations easily From a technical perspective, the performance has been enhanced and optimized for a limited number of flows. The content settings are more advanced, and there are so many other features that I can't name them all."
- "BW/4HANA could improve query optimization. For example, there could be an error message that pops up when you hover over it if any query fails. That would make it easier to find out what went gone wrong. Guided SAP help tools would make it easier for us to go forward."
What is our primary use case?
We are using HANA for dashboarding. HANA is like a database for the system where we create dashboards using business planning and consolidation on AE4 and EPM. Five or six people are on the business warehouse team managing BW/4HANA, and I'm the architect, so I help them.
What is most valuable?
The UI is completely new, beautiful, and user-friendly. There are some other helpful features like global filters and advanced tools. We can perform custom calculations easily
From a technical perspective, the performance has been enhanced and optimized for a limited number of flows. The content settings are more advanced, and there are so many other features that I can't name them all.
What needs improvement?
BW/4HANA could improve query optimization. For example, there could be an error message that pops up when you hover over it if any query fails. That would make it easier to find out what went gone wrong. Guided SAP help tools would make it easier for us to go forward.
For how long have I used the solution?
I have been using BW4HANA for almost six or seven months now.
What do I think about the stability of the solution?
BW/4HANA is quite stable unless we come up with different service sites.
What do I think about the scalability of the solution?
There are some old systems that have been discontinued, and it'll be challenging if you migrate completely to a new system. I'm not sure whether every organization wants to do that, but so I cannot speak to the scalability.
How was the initial setup?
SAP BW/4HANA is easy to set up. It's a little tricky when it fails, but I did not find it challenging. You need to have all the help files installed before starting the setup. The deployment is fast.
What's my experience with pricing, setup cost, and licensing?
I can't comment on the cost because it keeps changing based on the plan and company requirements. There are different procedures and corporate discounts.
What other advice do I have?
I rate SAP BW/4HANA seven out of 10. It's user-friendly, so it's easy to get started on it.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
SAP BW4HANA
December 2025
Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,768 professionals have used our research since 2012.
Senior Managing Director at a tech services company with 51-200 employees
Can be used more generally as a data warehouse and has the ability to utilize predefined content
Pros and Cons
- "We benefited from BW/4HANA's ability to utilize predefined content inside. We didn't need to start from scratch."
- "The solution is not easy to implement. It requires a lot of learning at the beginning."
What is our primary use case?
We are a consulting company, we use the solution for our client's organizations who have a basic requirement for KPI information.
Our customers require KPIs to analyze their management. We use BW/4HANA to extract data and provide business intelligence for our customers that are using S/4HANA ERP.
What is most valuable?
SAP BW/4HANA can be used more generally as a data warehouse. Prior to BW/4HANA, BW classic could only work with SAP products, but S/4HANA can be used for any enterprise data warehouse and is no longer limited to SAP, but can also be used for legacy data or big data. The solution is more flexible than before.
We benefited from BW/4HANA's ability to utilize predefined content. We didn't need to start from scratch.
What needs improvement?
The solution is not easy to implement. It requires a lot of learning at the beginning. I would like to see the features be simplified.
For how long have I used the solution?
I have been using SAP BW/4HANA for five years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
SAP BW/4HANA is not a cloud version, it does not have auto-scaling functionality. It is scalable, but it is not automatic.
Which solution did I use previously and why did I switch?
In the past, for data warehousing, we used Oracle, Google BigQuery and AWS. For business intelligence, we used BusinessObjects as a solution.
How was the initial setup?
BW/4HANA is not easy to implement, it is complex. It requires four or five people to implement.
Before, in BW classic, there is BW Workbench. Inside Workbench, we could do almost anything without needing to go to the database level. Now, the architecture has changed. We need to use Eclipse to model the data, making it more technical than before. It is difficult to train our customers.
If an upgrade is needed, it takes about five months to implement, depending on what the client currently has. If we are implementing a new BW/4HANA from the beginning, it will take more time to analyze the requirements.
What's my experience with pricing, setup cost, and licensing?
SAP BW/4HANA is expensive.
What other advice do I have?
SAP BW/4HANA did not require us to start from scratch as it utilizes predefined content inside.
I would rate this solution an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner/Integrator
SAP Technical Director at a tech services company with 201-500 employees
Useful for connectivity with external systems, but the connectivity requirement is high and requires up-to-date systems
Pros and Cons
- "The solution is useful for connecting with external systems."
- "From a technical perspective, it could be even more related to legacy systems. The connectivity requirement is quite high and requires systems that are up-to-date."
What is our primary use case?
I'm a reseller and implementer.
There are about 20 consultants using this solution on a daily basis.
What is most valuable?
The solution is useful for connecting with external systems.
What needs improvement?
From a technical perspective, it could be even more related to legacy systems. The connectivity requirement is quite high and requires systems that are up-to-date.
There's a lot of competition. If a customer isn't already using SAP, they should also consider other tools.
For how long have I used the solution?
I have used this solution for three years.
What do I think about the stability of the solution?
The stability has improved a lot. It's becoming a more mature product.
What do I think about the scalability of the solution?
We haven't had any issues with the scalability. It has also improved significantly.
How are customer service and support?
SAP's technical support is okay as long as you follow the process. I would rate technical support as three out of five.
How was the initial setup?
I would rate the setup as four out of five. The documentation has improved, so it's not that difficult.
What's my experience with pricing, setup cost, and licensing?
The cost and licensing depends on how the customer is going to use the solution.
What other advice do I have?
I would rate this solution as seven out of ten.
Overall, it's hard to compare with other products on the market, but I think it has improved quite significantly.
For those who are interested in using this solution, my advice is to do a trial of the solution because it's a good way to get started and will make implementation faster.
Disclosure: My company has a business relationship with this vendor other than being a customer. Reseller/Implementer
Stable solution that provides good DW implementation for customers who already implement SAP ERP
Pros and Cons
- "The solution is based on SAP ERP, so there's some business content already included. For customers who use SAP ERP, SAP BW4HANA is a good choice for their DW implementation."
- "It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools."
What is our primary use case?
We are consultants and distributors for BW4HANA.
SAP wants to transition all of their customers to the cloud, so they have announced a lot of policies that will support the on-premise product until 2024 or 2025. That's a good opportunity for us to transition our customers to the cloud.
What is most valuable?
The solution is based on SAP ERP, so there's some business content already included. For customers who use SAP ERP, SAP BW4HANA is a good choice for their DW implementation.
What needs improvement?
It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools.
The product is complex, so I think it could be simplified.
For how long have I used the solution?
I have used this solution for five years.
What do I think about the stability of the solution?
It's stable.
What do I think about the scalability of the solution?
The on-premise product isn't very easy to scale up, but implementing it in the cloud is much easier.
How are customer service and support?
Technical support is pretty good. SAP doesn't respond immediately, but they deal with the most critical issues.
How was the initial setup?
Initial setup was easy.
Which other solutions did I evaluate?
We don't refuse any kind of opportunity that our customers want to implement, so we are trying to learn about analytics solutions from Microsoft and Google.
What other advice do I have?
I would rate this solution as eight out of ten.
If someone wants to implement BW4HANA, it's important to do a training course first and think about the strategy they would like to use to leverage the data for their business.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
Sr SAP Cloud Architect at a tech services company with 10,001+ employees
Has all the data warehouse features, but licensing could be better
What is most valuable?
SAP BW/4HANA is the same as the old SAP BW system, except that it's being hosted on HANA. Nowadays, SAP HANA is coming out with all the data warehouse features. You don't have to have SAP BW on HANA, HANA itself can offer that. SAP as 4HANA itself is taking over because it supports both OLTP and OLAP transactions at the same time.
What needs improvement?
One thing is that it costs more because you have to acquire that license for the product, which itself is a waste. If you can do that without the product, that's one thing. And then the performance. Performance is never so good with the old model, BW model that SAP developed because you need to extract the data, you have to load it, you have to put it into cubes, and you have to build your own warehouse, then it's ready for reporting, which is a very convoluted process. It's a long journey and a tedious job every day, every week, but that's how the world was working for several years.
If anything, they should only make it faster. You cannot blame the product completely because it depends on how well you built your cubes, as well as the database objects inside the data warehouse, and how efficient your SQL is.
For how long have I used the solution?
I've been using this solution for about three years.
What do I think about the stability of the solution?
The system has always been stable.
What do I think about the scalability of the solution?
The scalability is fine. The limitation is not the product, but limitation is the hardware for HANA because HANA hardware is very expensive. Everyone has to be very cognizant about how much data is really required and what data needs to be pushed. Otherwise the hardware costs for HANA database is going to be very, very expensive.
What other advice do I have?
I would rate this solution a seven out of ten because it's not bad. The world has been running with the same product for several years, but now new products and new technologies are coming. They have their own challenges. That doesn't mean that this is bad.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
Senior Strategy Manager at a comms service provider with 10,001+ employees
Reliable, scalable, and has good support but they need more integration
Pros and Cons
- "I like that it's quite quick."
- "I would like more integration."
What is our primary use case?
I was a developer.
We use this solution for sales reporting and financial reporting.
What is most valuable?
I like that it's quite quick.
What needs improvement?
I would like more integration.
Cost is a factor. It could be improved.
The installation could be simplified.
For how long have I used the solution?
I have been using SAP BW4HANA for seven years.
The version that I dealt with was 7.4, and the company I am in now is using the latest version.
I am just starting to use that now.
What do I think about the stability of the solution?
SAP BW4HANA is very stable.
What do I think about the scalability of the solution?
It's a scalable solution. I don't have any issues with the scalability of this product.
We have 200 to 300 users in our organization who use it.
How are customer service and technical support?
I have contacted technical support, they are generally very good.
Which solution did I use previously and why did I switch?
I used standard reporting, which didn't meet our needs and we had to go through a data warehouse.
How was the initial setup?
The initial setup is quite complex.
We are a worldwide team, we need quite a few people to manage this solution. We have a team of eight to manage this solution in Europe and close to the same to manage it in Asia.
We have a team of 14 or 15 to manage this solution worldwide.
What's my experience with pricing, setup cost, and licensing?
In general, it's quite expensive.
What other advice do I have?
I would recommend this solution in certain circumstances, but for others, probably not. It all depends on what the use case was.
I would rate SAP BW4HANA a seven out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
Head of Enterprise Reporting & Analytics at a manufacturing company with 10,001+ employees
Good capabilities, direct approach, and the right reporting tool for SAP companies
Pros and Cons
- "Its direct approach is the most valuable. You get more real time and capabilities than BW."
- "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."
What is most valuable?
Its direct approach is the most valuable. You get more real time and capabilities than BW.
What needs improvement?
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.
For how long have I used the solution?
SAP BW4HANA is a relatively new product from the SAP side, but we have been running almost a two years project now and moving from BW to BW4HANA. So, it is a completely new build of the entire environment. We just completed that in November last year.
Which solution did I use previously and why did I switch?
We have used BW and HANA Native. BW4HANA is definitely much better than BW. It is also much better than HANA Native.
How was the initial setup?
It depends on your experience, the approach, and so on. I took over the project when it was already started. It had been running for two or three months. I would have approached it differently if I was there during the kickoff. It is challenging when you are too much focused on old products, and you don't have a good model in place or a good understanding of the business model. For me, it was not so difficult. I did it a lot in my former positions and during many years of experience in multidimensional data modeling, but for most of my colleagues and my team members, it was quite challenging because they had more experience in reporting subs, SQL subs, and so on and not so much experience in data modelings and so on.
In general, you need to acquire experience in this. There are not so many in the market. I also had a bad experience with consulting companies. I had to correct them and technically detail the process for how to do this.
It is simply the mindset. When we approach it with the mindset of how it was done in BW or HANA, you get a process that is not really efficient. When object-oriented approaches are not taken into consideration, everything gets built a hundred times, and instead of being more object-oriented, it gets quite complex. It always requires good modeling and an understanding of the business requirements, which can be quite challenging.
What's my experience with pricing, setup cost, and licensing?
We started as early birds from the SAP side. We got this entire suite for free. I cannot really talk about the price because we didn't have to pay anything.
What other advice do I have?
It makes sense for all enterprise companies that currently have BW in place to move over because BW4HANA has more reasonable performance, and it helps you in getting reporting. An enterprise can manage the reporting on this one product. In my previous company, I had to do and review reporting for end-users at the aggregated management level, not only at the transactional level.
I would rate this solution an eight out of ten. It is definitely an eight for reporting low and high at the management level as compared to others, but it is also dependent on the design. I had to provide and I still need to provide a lot of things knowing how my former colleagues have approached those things. From my point of view, it is never always the product, it is the experience we have in the design and context. BW4HANA is definitely much better than BW. It is also much better than HANA Native. It is definitely the right tool in terms of reporting and security on top of the SAP companies. Most of the companies are SAP companies. If you need an additional reporting tool on top, this is a solution.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Download our free SAP BW4HANA Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2025
Product Categories
Data WarehousePopular Comparisons
Teradata
Snowflake
Oracle Exadata
OpenText Analytics Database (Vertica)
VMware Tanzu Data Solutions
Amazon Redshift
Apache Hadoop
SAP IQ
IBM Db2 Warehouse
Infobright DB
Microsoft Parallel Data Warehouse
Microsoft Analytics Platform System
SAP NetWeaver Business Warehouse
WP Bolt
Buyer's Guide
Download our free SAP BW4HANA Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- SAP BW4HANA vs Microsoft SQL Server: are they comparable?
- How do I extract SAP BW data models and SAP HANA data models?
- Which do you prefer: SAP BW/4HANA on the cloud or SAP BW on Azure?
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?
- Is a data warehouse the best option to consolidate data into one location?
- What are the main differences between Data Lake and Data Warehouse?
- Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
- What is the best data warehouse tool?















