Try our new research platform with insights from 80,000+ expert users
it_user1202082 - PeerSpot reviewer
Deputy Manager with 1,001-5,000 employees
Real User
Calculates big data and has predictive analysis memory
Pros and Cons
  • "It can calculate data in detail. Before we could not calculate financial documents and accountant documents in detail, we could not do it at a document level but now we can. This is the most important feature. It also has predictive analysis memory."
  • "Not a ten because it's expensive and its ecosystem is not very open."

What is our primary use case?

1.We use it to generate operational analysis for our internal operations, for example, HR analysis, financial analysis, etc. 

2.We use SAP BW4HANA to calculate data and feed to Tableau / SAP BO to visualize data.

How has it helped my organization?

1. SAP BW4HANA's memory computing help us calculate into much more detail data  such as accouting document level. And it's very fast.

2. We have capabliity to realize requirements related to big data, real-time anlysis.

What is most valuable?

1.It can calculate big data. One year ago, SAP BW took us a lot of time around four hours to finish our process chains, but now it's better. 

2.It can calculate data in detail. Before we could not calculate financial documents and accountant documents in detail, we could not do it at a document level but now we can. This is the most important feature. It also has predictive analysis funationlity.

What needs improvement?

We already had a lot of cubes built-in based on SAP BW.  We hope these BW cubes can support real-time anlysis without migration to SAP HANA modeling.

Buyer's Guide
SAP BW4HANA
December 2024
Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,265 professionals have used our research since 2012.

For how long have I used the solution?

I have been using this solution for more than one year. 

What do I think about the stability of the solution?

We can draw down to the document level for a document. The problem is that when that document records are bigger than the platform, it causes the platform to slow down. 

How are customer service and support?

I have opened tickets with technical support. They've been good. Sometimes they take a while to respond. 

How was the initial setup?

The initial setup was complex.

What other advice do I have?

I would recommend SAP BW/4HANA.

I would rate it an eight out of ten. Not a ten because it's expensive and its ecosystem is not very open.

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.
PeerSpot user
Arijit_Sarkar - PeerSpot reviewer
Data Analytics Lead at a energy/utilities company with 1,001-5,000 employees
Real User
Top 10
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
PeerSpot user
Buyer's Guide
SAP BW4HANA
December 2024
Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,265 professionals have used our research since 2012.
BI Manager at a manufacturing company with 1,001-5,000 employees
Real User
Good technical support but the reporting performance is very poor
Pros and Cons
  • "The most valuable feature is that it's robust."
  • "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."

What is our primary use case?

We are currently using the on-premise deployment model. We have just started implementation for normal usage.

What is most valuable?

The most valuable feature is that it's robust. 

What needs improvement?

The performance for the reporting is very poor, there is no graphical report. The price to performance ratio is less. It's also very complex, for example, if I want to make a simple change I have to spend a huge amount of effort.

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

I am interested in seeing more graphical reports. SAP Cloud Analytics is an immature product on the market. They have started something to showcase to the customer that SAP also can do the graphical reporting, but still they need a lot of time. They should have similar features to Tableau and Qlik.

For how long have I used the solution?

I have been using this solution for twenty years.

What do I think about the stability of the solution?

It is stable. 

What do I think about the scalability of the solution?

It is scalable. We don't have many users, but with my previous experience, there is no limit. I can increase my hardware and I can use it for as many users as I want. We do have plans to increase the usage.

We require ten staff members for the deployment and maintenance. 

How are customer service and technical support?

Their technical support is good. 

Which solution did I use previously and why did I switch?

I previously used many solutions. I used Tableau, SAS, Oracle, Power BI, and SQL.

How was the initial setup?

The initial setup is complex in terms of implementing the basic objects.

In terms of how much time it took us to implement, for the standard features which are provided by SAP then it doesn't take that much time. It can be done quickly, but if you customize it takes longer. It depends upon the complexity of the business scenario. It's time-consuming if I compare the data to other products available on the market. If I compare it with Tableau then it is tremendously time-consuming. 

Tableau belongs to a totally different league but SAP BW is still not that good. It needs a lot of improvement.

What other advice do I have?

It's a good solution if you're integrating data from SAP software like ERP and looking out for the day-to-day reporting from the operational users at the lower level. If someone is looking for the quick, graphical reports and mobile availability then this is not the right solution for that. 

From an analytical perspective, I would rate it a two out of ten but from the business warehouse perspective, I would rate it a five.

From an analytical perspective, I would rate it two because it's not competent in the current scenario of the market. The reports take a huge amount of time because it just uses its basic features called Microsoft Analysis Office which is like Excel reporting and no one wants to see data in Excel reports.

Businesses want to see the data in terms of the graphs, which can be easily readable compared to the numbers. If I'm giving the data in numbers or charts, the charts should be easily understood. Whereas BW provides data in Excel, so someone has to sit and create their own reports on top of it, which takes a lot of time.

The second thing is the execution time for the reports generation. Even due to the limitation of the analysis of the office I cannot process more than around 10 million records. It takes a lot of time to forget about 100K records. It takes a lot of time to load the data, whereas if I compare this with Tableau, it loads in milliseconds or seconds.

If I'm going to meet some of my customers and then if I decide that I want to check something about what the customer is talking about, for example, I cannot do that. I need to login, I need to connect to my SAP systems, then I need to execute the report and then see what the data is. Mobile availability is not there. While having a discussion with the customers I can include the report on my tab with Tableau. This is lacking in BW.

I had to tell a customer that I had to check the information and get back to him. I had to spend half an hour trying to call someone either from IT or someone in my back office to get the data and provide it to the customer. That was rubbish.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Sunishta Singh - PeerSpot reviewer
Professor at Furtwangen University
Real User
Top 20
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?

As a user, I use the solution for BW data modeling, customization, remodeling, process changes, and creating queries, workbooks, and analyses.


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.


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.
PeerSpot user
BI Manager at a manufacturing company with 1,001-5,000 employees
Real User
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.
PeerSpot user
reviewer1749831 - PeerSpot reviewer
Sr SAP Cloud Architect at a tech services company with 10,001+ employees
Real User
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
PeerSpot user
reviewer1260159 - PeerSpot reviewer
IT Director at a healthcare company with 10,001+ employees
Real User
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.
PeerSpot user
PeerSpot user
Senior Strategy Manager at a comms service provider with 10,001+ employees
Real User
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
PeerSpot user
Buyer's Guide
Download our free SAP BW4HANA Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2024
Product Categories
Data Warehouse
Buyer's Guide
Download our free SAP BW4HANA Report and get advice and tips from experienced pros sharing their opinions.