Try our new research platform with insights from 80,000+ expert users
Contractor at MISA
Real User
Top 5
A data warehousing solution to pull and extract data but needs flexibilty
Pros and Cons
  • "The solution seamlessly integrates with SAP products."
  • "We cannot integrate with third-party tools like Python or advanced integration options. You can't fine-tune tables within BW or generate specific views or reports."

What is our primary use case?

We use SAP BW4HANA as our data warehousing solution. We pull data from different sources and extract it into the central data warehouse. We analyze and visualize it using analytical engines such as Tableau or SAP Analytics Cloud.

What is most valuable?

The solution seamlessly integrates with SAP products but lacks other advantages. 

We use it because underlying SAP products are compatible with easy integration.

What needs improvement?

We tried integrating SAP BW4HANA with several platforms, but none worked properly. It lacks customization options. It's neither flexible nor elastic, making simple job creation difficult. There's no support for developing data cards or similar functionalities. Its data management and endpoint data governance features are lacking. 

We cannot integrate with third-party tools like Python or advanced integration options. You can't fine-tune tables within BW or generate specific views or reports.

The product roadmap and features of SAP BW4HANA are ugly and need improvement.

For how long have I used the solution?

I have been using SAP BW4HANA for three or four years.

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.

What do I think about the stability of the solution?

The product is stable, but if it fails to meet the basic needs. It doesn't support my development lifecycle for the data warehouse.

What do I think about the scalability of the solution?

The solution is not scalable. 15-20 different departments are using it because there is no other solution.

I rate the solution’s scalability minus five out of ten.

How are customer service and support?

There are no support issues. The overall product has concerns, including its dimension, roadmap, evolution with the cloud, and integration with non-SAP systems. Maintaining insight into these matters is crucial, and support helps to address them.

What other advice do I have?

It's been 10-12 years since SAP BW4HANA evolved from its older versions, but the product hasn't improved much. Unlike competitors such as Microsoft and Snowflake, who continuously evolve their products, SAP BW4HANA lacks seamless integration with third-party connectors. This absence of support for good integration tools suggests a monopolistic approach. Simple integrations take excessive time, leading to low business efficiency. SAP's core applications are highly customizable and purpose-built, with continuous release cycles that align with market trends.

The maintenance of the solution is challenging due to its complex architecture. However, its dynamic design and comprehensive features make it unique. Even a minor with database knowledge can significantly improve the schema creation process.

I don't recommend the solution. It's not fair to compare bananas to oranges. There's no comparison. SAP doesn't fall anywhere close to other vendors.

If you are a static organization with basic SAP applications in the underlying architecture, SAP BW4HANA will be a better choice. However, with the evolution of data and the increasing amount of data being collected, along with emerging applications, it's not advisable to use it. It will complicate your life, leading to disappointment for your business and SAP's overall strategy for the organization.

Overall, I rate the solution a five out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Shaik Abdul Khadar - PeerSpot reviewer
Chief Executive Officer at a tech services company with 11-50 employees
Reseller
Very robust but is expensive
Pros and Cons
  • "Technology-wise, it is a very robust tool."
  • "The problem is the expensive pricing of technical support, making it an area where improvements are required."

What is our primary use case?

I am working with multiple SAP clients. I am more of a tool consultant. We now have our own solutions for the supply chain, but they are more focused on complementing SAP solutions.

What needs improvement?

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

For how long have I used the solution?

I have been using SAP BW4HANA for three to three and half years.

How are customer service and support?

The solution's technical support can be expensive. If you pay the support team, the support team will offer you support. If you don't pay the support team, they will not support you. My company never had any problem with SAP, but it is very pricey.

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

My company uses SAP Analytics Cloud for dashboards. The data source could be BW, or it could be directly SAP S/4HANA, and sometimes we do it like that. For one of the clients, we did not do it in BW and went directly to HANA database because their requirements weren't much.

How was the initial setup?

My company helps customers with the implementation of the tool. We also offer support and customize our products for the customers.

The product's implementation phase is not straightforward. A few things have to be taken care of, and it all depends on the people doing it. We have very experienced people to take care of the tool's implementation. Sometimes, people implement the tool very quickly, and if they have any issues, they will take more time, but it gets delivered. We don't have any problem with the tool's implementation.

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

The tool is affordable. In our company, we do have the capacity to offer the tool to others based on the cost, capability, needs and what someone expects from the tool for their overall project. Everything depends or varies because not all clients are the same. If clients opt for our company's complementing solutions, we give a different pricing model to such customers, meaning we have a model to support them.

Which other solutions did I evaluate?

There are multiple products in the market. People are looking for multiple things, but I am not sure.

What other advice do I have?

I recommend the tool for companies involved in manufacturing and logistics. Our primary focus is on mid-sized businesses.

The clients know what is required for their companies. Our company's main focus is manufacturing and supply chain organizations. The tool can also be used in mining and certain parts of retail business.

The products offered by SAP have high levels of competence. Companies look for tools that can solve their problems at an affordable price.

My company integrates the product with other tools with the help of SAP OData's services.

Speaking about the tool's impact on the customers' data processing speeds, I would say that one of the main concerns is security. The tool is more concerned about the security of the integrations. That is the reason the tool is preferred through something like AWS or GCP. The security of SAP integration is a major concern for the client as they don't want to expose their data to unsecured links. Some customers are okay with the tool's integrations, but my company uses SAP OData for others. Sometimes, if a customer is not willing to share, we use RPA for some integrations.

The tool's modernized data modeling capabilities are mandatory, so it is no longer an option. Users need to have robust data, and if they don't have a robust data architecture, they will have a problem anyway. It is not only about their recurrent operations but also associated with future upgrades. Everybody is trying to be innovative sooner or later.

Speaking about the transition from a traditional data warehouse to an SAP tool and its impact on our customers' data governance practices, I would say that they will get all the data requirements fulfilled after migration. If they don't design it properly, then they will have a problem, and it can be technological or functional.

I recommend the tool to others.

The tool has its own challenges. Technology-wise, it is a very robust tool. From the cost and implementation perspective, I rate the tool as a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
Flag as inappropriate
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.
reviewer2278119 - PeerSpot reviewer
FTTP Engineer at a comms service provider with 10,001+ employees
Real User
Top 20
The product has good reporting features, but it is not cloud-compatible
Pros and Cons
  • "I like the reporting features of the solution."
  • "The tool is not cloud-compatible."

What is our primary use case?

It is a data warehouse product. It is used to extract data from source systems, unify it, and gain business intelligence.

What is most valuable?

I like the reporting features of the solution.

What needs improvement?

The tool is not cloud-compatible. It is an on-premise tool. SAP is bringing other tools into its place.

For how long have I used the solution?

I have been using the solution for ten years. I am using the latest version of the solution.

What do I think about the stability of the solution?

The tool is stable.

What do I think about the scalability of the solution?

The product is scalable. On-premises systems cannot be scaled easily, though. Cloud solutions are easily scalable. Approximately 200 to 300 people use the solution in our organization.

How are customer service and support?

The tool was implemented in my company 15 years ago. For the last 15 years, we have been in constant touch with SAP.

How was the initial setup?

The initial setup is straightforward. The administration team does it. The team buys the licenses from SAP, downloads the software, and installs it on SAP servers. The deployment did not take more than one day.

What about the implementation team?

The deployment can be done in-house. Our organization pays SAP, and we download the software and install it. It’s straightforward.

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

The product is free if we have the ECC license.

What other advice do I have?

The product is not relevant anymore. Other modern tools are better than SAP BW/4HANA. I will not recommend the solution to others. Overall, I rate the solution a six 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
Sivaiah Pa - PeerSpot reviewer
Specialist BI at a logistics company with 10,001+ employees
Real User
Top 10
Offers good visualization and less redundant data but needs improvement in performance
Pros and Cons
  • "We can get good visualization and less redundant data."
  • "The product needs to improve with more performance and fewer data layers."

What is our primary use case?

We use SAP BW4HANA for revenue reporting. 

What is most valuable?

We can get good visualization and less redundant data. 

What needs improvement?

The product needs to improve with more performance and fewer data layers. 

For how long have I used the solution?

I have been working with the product for six months. 

What do I think about the stability of the solution?

I rate SAP BW4HANA's stability a nine out of ten. 

What do I think about the scalability of the solution?

I rate the tool's scalability an eight out of ten. 

How was the initial setup?

SAP BW4HANA's deployment is not complex. You need five to ten people to handle the maintenance. 

What was our ROI?

SAP BW4HANA has helped us save time and money. 

What other advice do I have?

I rate the product an eight 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
reviewer1426734 - PeerSpot reviewer
Head of Enterprise Reporting & Analytics at a manufacturing company with 10,001+ employees
Real User
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Project Manager - Analytics at Mindsprint
Real User
Top 10
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
PeerSpot user
Wonjae BAE - PeerSpot reviewer
Senior Managing Director at dfocus
Reseller
Top 10
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
PeerSpot user
Freelancer at 0
Real User
Top 20
Provides good features, saves time and cost, and can be used as a data source
Pros and Cons
  • "The solution saves time and cost."
  • "There should be a direct pipeline from Azure to SAP."

What is our primary use case?

We use the solution to build up complex queries that support data models and reporting.

How has it helped my organization?

The solution saves time and cost. Our dependability on SAP has reduced because we use BW4HANA as an intermediate system that works as a data source for different tools. We don't have to connect the other tools to SAP directly. Our data is secured. BW4HANA is like a staging environment. We can use it to supply data to other programming or reporting tools.

What is most valuable?

All the features are important. BW queries, BW views, calculation views, and calculated columns are valuable features. InfoCubes and InfoObjects are also valuable features. The product speeds up the data read cycle.

What needs improvement?

There should be a direct pipeline from Azure to SAP. Users must be able to deploy the pipeline and pull the tables directly.

For how long have I used the solution?

I have been using the solution for four to five years.

What do I think about the stability of the solution?

I rate the product’s stability an eight out of ten. The stability has some scope for improvement.

What do I think about the scalability of the solution?

The tool is highly scalable. I rate the scalability a nine or ten out of ten. About seven to eight developers use the solution in our organization.

What other advice do I have?

We have integrated SAP with Azure. We have migrated all standard tables and the output of standard reports on Azure. A different team in our organization coordinates with the solution’s support team to resolve the issues we face. I will recommend the solution to others. If a huge amount of data needs to be moved around for analytics purposes, we should choose SAP BW4HANA. Overall, I rate the tool an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
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.