Try our new research platform with insights from 80,000+ expert users
Lead Consultant at a computer software company with 10,001+ employees
Real User
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.

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

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 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
PeerSpot user
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
SAP BW4HANA
May 2025
Learn what your peers think about SAP BW4HANA. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
it_user1477425 - PeerSpot reviewer
Associate Manager at a consultancy with 1,001-5,000 employees
Real User
Stable, scalable, and good performance, but expensive
Pros and Cons
  • "Some of the main features of this solution are that it uses HANA and it has good performance."
  • "Other competitors provide better solutions that are more up to date with current technology."

What is our primary use case?

We use the solution in a data warehouse.

What is most valuable?

Some of the main features of this solution are that it uses HANA and it has good performance.

What needs improvement?

Other competitors provide better solutions that are more up to date with current technology. For example, machine learning and artificial intelligence.

For how long have I used the solution?

I have been using the solution for approximately 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?

There are no issues with scalability with this solution.

How was the initial setup?

The installation is complex.

What about the implementation team?

We used the SAP team to do the installation for us. We have a vendor who takes care of the maintenance of the server. 

What's my experience with pricing, setup cost, and licensing?

As an investment, the solution is very expensive. We pay 72% every year to SAP. Additionally, we pay for support for the solution and a vendor to do maintenance.

Which other solutions did I evaluate?

I have evaluated Talend, Azure Cloud, and Google Cloud which have better features.

What other advice do I have?

I would not recommend the solution because they have not upgraded their technology.

I rate SAP BW4HANA a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
SAP Technical Director at Key Performance Consulting
Reseller
Good reporting, well-suited for medium to large-sized organizations
Pros and Cons
  • "The most valuable features are the speed of reporting and the HANA database."
  • "It takes too long to escalate problems from the first level of support."

What is our primary use case?

We are a solution provider and this is one of the products that we implement for our clients.

What is most valuable?

The most valuable features are the speed of reporting and the HANA database.

What needs improvement?

I find the migration from an existing BW platform to be quite difficult. It is quite cumbersome for our customers to migrate to BW 4HANA.

The impact that it has on the ECC/ERP system is a problem because they are relying solely on the ODP tool to perform the extract.

It takes too long to escalate problems from the first level of support.

For how long have I used the solution?

I have been using this solution for a bit less than two years, from around the time that it came out.

What do I think about the stability of the solution?

Stability is something that needs to be improved. There are too many SAP nodes to implement on a regular basis to get everything working.

What do I think about the scalability of the solution?

It is a scalable solution but it depends on the hardware. Our clients vary in size from small to very large organizations, although for this product, most of them are at least of medium size.

How are customer service and technical support?

The technical support is okay, although it can be improved because sometimes it takes too long to get the correct expert to deal with the issue. Essentially, the wait at the first level of support causes us to lose time.

How was the initial setup?

The initial setup is rather complex. It can be up and running in two or three days but it takes a week to have it perfectly implemented.

We implement both on-premises and cloud-based deployments for SAP BW 4HANA.

What about the implementation team?

Our in-house team does the implementation and deployment for our customers.

What other advice do I have?

This is a good product and one that I recommend implementing. 

As we look at the information we have for the cloud solution, it would be helpful to have something more clear from the vendor in terms of strategy. More information on the direction of the data warehouse solutions, going forward, would be helpful. Today, there is a market for HANA both on-premises and in the cloud, but the data warehouse cloud solution that is coming up is quite different.

I would rate this solution an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
reviewer1298316 - PeerSpot reviewer
Cloud Solutions Architect and Analytics at a tech services company with 10,001+ employees
Real User
The infrastructure is easy to understand and it has good stability
Pros and Cons
  • "The most valuable aspect of this solution is that the infrastructure is easy to understand."
  • "Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."

What is most valuable?

The most valuable aspect of this solution is that the infrastructure is easy to understand. 

What needs improvement?

Pricing would be a good improvement. A lot of customers think that it's very expensive and support is especially very expensive. 

For how long have I used the solution?

I have been using this solution for two to three years. 

What do I think about the stability of the solution?

Stability and scalability are both good.

How was the initial setup?

The setup requires a specialist but it's not too complex.

What's my experience with pricing, setup cost, and licensing?

We have to pay extra in addition to licensing. Migration to HANA has costs that are higher than expected. 

What other advice do I have?

I would rate it an eight out of ten. 

It costs a lot for a company to invest in SAP. It could be hard for a company to invest in it. It should be a little cheaper, it would raise the score to a nine.  

If a customer wants to save costs, they should move their infrastructure from on-premise to public cloud. 

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: Distributor
PeerSpot user
reviewer1308417 - PeerSpot reviewer
Senior Consultant SAP / BW / SAP BOBJ at a tech services company with 51-200 employees
Real User
Top 10
Helpful dashboard and reporting with good technical support, but the interface should be simplified
Pros and Cons
  • "The most valuable feature is the dashboard."
  • "The dashboard should be simplified and made easier for exploration and decision making."

What is our primary use case?

I am a consultant and this is one of the solutions that I use for my clients.

In general, my clients use the dashboard and reporting services. They use it for modeling sales and service, material management, and stock management. They have automated reports that are sent daily by email.

The environment depends on the client.

What is most valuable?

The most valuable feature is the dashboard.

When using BW/4HANA, then is no performance degradation with Big Data.

What needs improvement?

The dashboard should be simplified and made easier for exploration and decision making.

Some customers have said that they would like to use the dashboard to send themselves data in an Excel file directly by email.

For how long have I used the solution?

I have been working with SAP BW/4HANA for eight years.

What do I think about the stability of the solution?

BW is a stable solution as long as it is on HANA. Otherwise, some applications with Big Data will result in performance issues.

What do I think about the scalability of the solution?

It is scalable but it depends on the server.

How are customer service and technical support?

I have dealt with technical support and they have been good.

How was the initial setup?

The installation of this solution is not simple, although configuring it is not a problem. 

What about the implementation team?

It is better to have help from integrators or consultants for the installation.

What other advice do I have?

My advice for anybody who is implementing this solution is to first follow the basics. It is possible that you will want some enhancements but you have to start at the beginning and start with the basic practice for modeling.

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
PeerSpot user
it_user1292418 - PeerSpot reviewer
SAP Enterprise Services Specialist at a tech services company with 10,001+ employees
Real User
Stable, scalable and easy to maintain
Pros and Cons
  • "The solution is easier to maintain than traditional SAP products."
  • "The solution does occasionally get a few bugs, but this is typical for any product."

What is our primary use case?

The solution is used for the reporting on various dashboards for analytical purposes.

What is most valuable?

HANA is based on a column store, and it is very effective for reading the data. 

BW has a major advantage because most of the activities on the BW system are reading data rather than writing data. 

The product, overall, is very good.

The solution is easier to maintain than traditional SAP products.

All of the information that is provided by the solution for managing the HANA database is excellent.

What needs improvement?

I can't think of anything the solution needs in terms of features to make it stronger. It's a great overall solution.

The solution does occasionally get a few bugs, but this is typical for any product.

For how long have I used the solution?

We've been using the solution for the past two years.

What do I think about the stability of the solution?

We have found the solution to be quite stable. It doesn't crash. It's been great.

What do I think about the scalability of the solution?

If a company needs to expand the solution, they can definitely scale up. It's quite easy to do so.

How are customer service and technical support?

We've reached out to technical support in the past. We reach out when there are some bugs or some specific issues on the product. They are very good. We've been satisfied with the level of support.

How was the initial setup?

I wasn't a part of the initial setup, so I can't speak to the implementation.

What other advice do I have?

We are SAP partners.

The solution is deployed on a scale-out environment, which involves five nodes of 1TB each. We have four worker nodes and one standby node.

I'm not the consumer of this product. I'm an administrator of it. I'm basically supporting this project but I'm not the actual customer.

I would definitely recommend the solution. It is the way forward if an organization is already in the SAP ecosystem. It's good to adapt to it sooner rather than later. I would definitely advise companies to implement it.

I would rate the solution nine out of ten. 

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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free SAP BW4HANA Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Product Categories
Data Warehouse
Buyer's Guide
Download our free SAP BW4HANA Report and get advice and tips from experienced pros sharing their opinions.