As a user, I use the solution for BW data modeling, customization, remodeling, process changes, and creating queries, workbooks, and analyses.
Professor at Furtwangen University
Robust and flexible solution for Data Analytics
Pros and Cons
- "SAP BW4HANA aids in managing data from ER to front-end analysis, contributes to ROI, and fosters business growth understanding. I like that the solution breaks down components to a very granular level, allowing for customization and implementation based on specific requirements. The solution is stable. The solution is scalable."
- "Challenges arise with real-time client requirements when clients are accustomed to Microsoft Excel's extensive features for data analysis. They expect similar flexibility and customization in the solution, particularly regarding headers displaying keys and descriptions or just keys. Achieving this level of customization can be challenging, and it's an area that may need improvement."
What is our primary use case?
How has it helped my organization?
SAP BW4HANA aids in managing data from ER to front-end analysis, contributes to ROI, and fosters business growth understanding.
What is most valuable?
I like that the solution breaks down components to a very granular level, allowing for customization and implementation based on specific requirements. Its structured approach provides flexibility.
What needs improvement?
Challenges arise with real-time client requirements when clients are accustomed to Microsoft Excel's extensive features for data analysis. They expect similar flexibility and customization in the solution, particularly regarding headers displaying keys and descriptions or just keys. Achieving this level of customization can be challenging, and it's an area that may need improvement.
Buyer's Guide
SAP BW4HANA
November 2024
Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,067 professionals have used our research since 2012.
For how long have I used the solution?
I have been working with the solution for over eight years.
What do I think about the stability of the solution?
The solution is stable. I rate it an eight out of ten.
What do I think about the scalability of the solution?
The solution is scalable. I rate it a seven out of ten.
How was the initial setup?
The solution is deployed on-premises and cloud, and the entire process took slightly over a week. I rate the setup as seven out of ten.
What's my experience with pricing, setup cost, and licensing?
The solution is expensive.
What other advice do I have?
To ensure smooth deployment, businesses must clearly understand their specific business processes before opting for any solution. Overall, I rate the solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
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
Buyer's Guide
SAP BW4HANA
November 2024
Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,067 professionals have used our research since 2012.
IT Director at a healthcare company with 10,001+ employees
Used for ERP with good financial costing and material management features
Pros and Cons
- "From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management."
- "In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
What is our primary use case?
The primary use case of this solution is for our ERP purposes.
What is most valuable?
From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management.
The only component that is not fully known is the HCM (Human Capital Management), but we have gone with SuccessFactors.
What needs improvement?
The HCM needs improvement, but as a company, they have stopped any development on this.
In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present.
For how long have I used the solution?
I have been using this solution for just over three months and we have just gone into production.
What do I think about the stability of the solution?
So far, we have not had any issues. This solution is stable.
What do I think about the scalability of the solution?
We have not had the opportunity to test the scalability, as we are retail at the moment and using it as a storage system.
At this point, we have only three users.
It is being used daily, but we plan to use it more extensively in the future.
How are customer service and technical support?
We have only contacted technical support once and they were helpful. Their response time was also good.
How was the initial setup?
The initial setup was straightforward and similar to other ERP deployments.
It took three months to deploy this solution.
What about the implementation team?
We had the help of a system integrator.
What other advice do I have?
I would look at the Cloud option. Although the Cloud is not mature enough at this time, people who are planning to deploy this solution perhaps a year down the road may benefit from it. The Cloud may be something they would want to consider.
I would rate this solution a nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
User-friendly and flexible with lots of standard features, but it needs to be more customizable
Pros and Cons
- "Out of the box, this solution has a lot of standard features."
- "Connecting multiple sources is a challenge because you have to go through a lot of different setups."
What is our primary use case?
We are a solution provider and this is one of the solutions that we implement for our customers.
We primarily use this solution for data warehousing and reporting.
What is most valuable?
This product is user-friendly.
Out of the box, this solution has a lot of standard features.
The product is quite optimized, having simple processes for change management and different security features. It offers a lot of flexibility.
Things are going more agile nowadays and you want to use a solution like BW/4HANA. It is more agile and more open to other sources. It integrates well with visualization tools like BusinessObjects.
What needs improvement?
This solution is very costly compared to competitors on the market, which stops some people from implementing it.
SAP has to be more customer-centric. They are aware of the standard business use cases but if changes are made then they are not aware of them, which makes the product more difficult to support.
You receive a standard product, which is fine, but it needs to be made more customizable.
Connecting multiple sources is a challenge because you have to go through a lot of different setups. For example, if you want to use FreeSQL then BW4/HANA lacks the support.
Some of the options that exist are very complex, which makes it tough to integrate.
For how long have I used the solution?
I have been using SAP BW/4HANA for the past six years.
What do I think about the stability of the solution?
As this is an on-premises solution, scalability can be a challenge. SAP claim that it is scalable, but I don't think so because it will add to your cost. I think that it should be more cloud-oriented. Basically, it can be scaled but it has its limitations.
We have perhaps 200 to 300 users in our company and it is being used on a daily basis.
What do I think about the scalability of the solution?
This is quite a stable tool.
How are customer service and technical support?
The support for this solution is good. The availability is good and the responses for more information are quick. However, it can sometimes take a long time to get a solution. Sometimes, it is so long that I can find the solution faster myself.
There is one problem for which I have not received a resolution. They have taken a lot of input from us, yet have been unable to pinpoint the problem. This is a challenge that I still face.
Which solution did I use previously and why did I switch?
I have tried Snowflake and it is also quite a flexible tool. It is more open in that you can bring in data from multiple sources by just installing some DLLs and parameter files.
How was the initial setup?
The length of time for deployment, to get everything up and ready to work, depends on several factors. For example, if depends on the number of objects and the number of reports that are needed. When we implement this solution for somebody, we do our estimation based on those two.
One of the projects that I worked on took approximately one year to go from the initial stage up until the point where it could be used for reporting purposes.
What's my experience with pricing, setup cost, and licensing?
This is an expensive solution and there are costs in addition to the standard licensing fees.
What other advice do I have?
SAP is introducing a lot of new features and making this product even more flexible.
The suitability of this solution depends on how big the business is and how much they want to invest in data warehousing. The effectiveness will vary from customer to customer. For example, I don't think that it is a good solution for small or medium-sized businesses because it is very costly. It involves a lot of maintenance costs and a lot of expertise. For a big customer, who is SAP-centric, with lots of SAP data or SAP business processes, this is one of the best data warehousing solutions.
Rating a product involves taking many things into consideration, such as scalability, performance, and security features. It also depends on what industry it is being used in.
Overall, I would rate this solution a seven 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
Project Manager - Analytics at Mindsprint
Has a simplified structure and better performance
Pros and Cons
- "It is a stable solution."
- "Price wise, this solution is on the higher side."
What is most valuable?
Simplified tables, advance DSOs, and composite provider are valuable features.
For how long have I used the solution?
I've been working with this solution for four years.
What do I think about the stability of the solution?
It is a stable solution.
How are customer service and support?
The technical support is okay.
How was the initial setup?
The initial setup is easy.
What's my experience with pricing, setup cost, and licensing?
Price wise, this solution is on the higher side.
What other advice do I have?
I would advise you to go ahead with SAP BW4HANA with minimal options to look into other solutions.
We found that SAP BW4HANA has better performance than NetWeaver Business Warehouse. Also, SAP BW4HANA has a simplified structure, advance DSOs, and a composite provider. These were not possible with NetWeaver Business Warehouse. This is because of the HANA database at the back end. Because of this, we have shifted 60% to BW4HANA and have 40% remaining on NetWeaver Business Warehouse. We have less than 5000 people using this solution.
Overall, I would rate SAP BW4HANA at nine 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
Data Analytics Lead at a energy/utilities company with 1,001-5,000 employees
Has a great analytics engine with the SEM-BCS app a critical feature
Pros and Cons
- "Provides a great analytics engine with all the capabilities."
- "The UI is not user-friendly."
What is our primary use case?
I'm a data analytics lead.
What is most valuable?
The Strategic Enterprise Management Business Consolidation System is the most valuable and critical feature of this solution. It also has a great analytics engine with all the capabilities I'm looking for. There are a lot of master and transitional data relationships where BW has very good features.
What needs improvement?
I love this product and have been working on SAP products for many years but the solution needs to be more user-friendly with an improved UI, particularly if you compare it to what Snowflake is offering.
For how long have I used the solution?
I've been using this solution for three 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?
The solution is scalable, we have around 200 users.
How are customer service and support?
Technical support from SAP is good and very structured. They are trying to improve day by day. They've got a good repository in terms of their knowledge base.
How was the initial setup?
The initial setup is not complex because we use HANA Studio. For anyone not in the SAP domain, it will be more complicated. We have two admins.
Which other solutions did I evaluate?
When comparing SAP to Snowflake, the difference is that Snowflake has a better UI and it's very quick to scale compared to SAP.
What other advice do I have?
It's important that SAP does not destroy the core value of what makes BW a great solution. They shouldn't abandon the star schema modeling so that anybody who wants to do 16 dimensions can keep their own shell, and can enhance user information on top of that.
I rate this product eight out of 10.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
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?
It's mainly used for finance. We use it for reporting.
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.
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: I am a real user, and this review is based on my own experience and opinions.
SAP Technical Director at Key Performance Consulting
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
Buyer's Guide
Download our free SAP BW4HANA Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Product Categories
Data WarehousePopular Comparisons
Snowflake
Teradata
Oracle Exadata
Vertica
VMware Tanzu Data Solutions
Apache Hadoop
Oracle Database Appliance
IBM Db2 Warehouse
SAP IQ
Microsoft Parallel Data Warehouse
SAP NetWeaver Business Warehouse
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?