No more typing reviews! Try our Samantha, our new voice AI agent.

Microsoft Analytics Platform System vs SAP BW4HANA comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Microsoft Analytics Platfor...
Ranking in Data Warehouse
18th
Average Rating
6.6
Reviews Sentiment
6.8
Number of Reviews
9
Ranking in other categories
No ranking in other categories
SAP BW4HANA
Ranking in Data Warehouse
11th
Average Rating
7.6
Reviews Sentiment
6.4
Number of Reviews
45
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of August 2026, in the Data Warehouse category, the mindshare of Microsoft Analytics Platform System is 2.3%, up from 1.0% compared to the previous year. The mindshare of SAP BW4HANA is 3.4%, down from 4.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Mindshare Distribution
ProductMindshare (%)
SAP BW4HANA3.4%
Microsoft Analytics Platform System2.3%
Other94.3%
Data Warehouse
 

Featured Reviews

MahmoudMohamed1 - PeerSpot reviewer
Senior Data Engineer at Tatweer Educational Technologies Company - TETCO
Offers smooth data integration between systems, but requires better real-time analytics capabilities
We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services. This lets us continue using private databases without paying additional licensing fees. Additionally, the license includes Analytics services and Power BI, which work on-premises, unlike most other technologies that require cloud solutions.
Ritesh Durvasha - PeerSpot reviewer
Senior consultant at a consultancy with 10,001+ employees
Has supported efficient data processing and streamlined reporting for large-scale sales operations
The capability to handle a large amount of data and perform ETL operations is most valuable. Additionally, sending data out of SAP BW4HANA through Open Hub, which is a free service, is another valuable feature. In contrast, many other products charge for sending data out of their systems, such as Data Sphere or BDC, which charge premium service fees. Regarding advanced analytic tools in SAP BW4HANA, users can directly connect to Analysis for Office without additional charges. It's convenient as users don't have to download data into Excel since it's already connected to the system. From an integration capabilities perspective, it's easy to connect to SAP systems, though integration with non-SAP systems presents more challenges.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"It is closely integrated with other products in the MS portfolio."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"I like that it's integrated with other Azure products."
"This is a well-integrated solution and that integration empowers results."
"We help customers in many ways from customized analysis for detection of anomalies in tax, operations, customer relationship, and marketing campaigns, and we also use mining and ML to help them discover trends, which provides useful information based on their business."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"SAP BW4HANA's memory computing helps us calculate much more detailed data, such as accounting document level, and it's very fast."
"Its direct approach is the most valuable. You get more real time and capabilities than BW."
"The product has efficient performance."
"The solution saves time and cost."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"It is a stable solution."
"I rate this solution a 10."
"The features I find most valuable in SAP BW4HANA include the minimal modeling optics, where earlier in the BW System we had a lot of modeling objects for things like virtualization and data staging, but in SAP BW4HANA they have simplified everything, allowing us to design data by using minimal objects combined into a single object."
 

Cons

"The trouble is Microsoft has changed their licensing. It's an extremely expensive product now."
"On a scale from one to ten where one is the worst and ten is the best, I would rate this product overall as a five. This is probably because there is still a lot of room for improvement, features that other products have that are missing, and a lot of open-source technology nowadays that are very good and people can use instead."
"​Hybrid environments are complex to manage."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"Functionality needs to be more up-to-date with competing products."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Microsoft Analytics Platform System could have better support."
"There's the complexity in migration from BW to BW/4HANA, especially with data migration."
"This solution is very costly compared to competitors on the market, which stops some people from implementing it."
"The HCM needs improvement, but as a company, they have stopped any development on this."
"The interface could be more user-friendly, as we often need to do low-level coding to get things done."
"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 improvement, I think AWS for HANA could be better, but it is an on-premise solution."
"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."
"I would like to be able to design new reports in a future release."
 

Pricing and Cost Advice

"Users have to pay extra for premium-level technical support."
"I rate Microsoft Analytics Platform System a seven out of ten for pricing."
"We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
"The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
"The price is high and currently only affordable for large organizations."
"We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses."
"SAP BW/4HANA is expensive."
"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
"It is an expensive product."
"The product is free if we have the ECC license."
"For some, the rates offered by SAP can be costly while for others it may seem cheap. The price ultimately depends on how you have negotiated your contract with SAP."
"The solution is expensive."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
908,858 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
11%
Manufacturing Company
10%
Retailer
9%
Construction Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Large Enterprise7
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise4
Large Enterprise30
 

Questions from the Community

Ask a question
Earn 20 points
What needs improvement with SAP BW4HANA?
For improvement, I think AWS for HANA could be better, but it is an on-premise solution. SAP is asking us to move to one client approach and suggested moving to data warehouse cloud, which should h...
What is your primary use case for SAP BW4HANA?
My use cases involve the client I am working with, who already has a BW ON HANA system, and we are currently migrating and redeveloping things in SAP BW4HANA; they are decommissioning the BW On HAN...
 

Also Known As

Microsoft APS, MS Analytics Platform System
SAP BW/4HANA
 

Overview

 

Sample Customers

Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
Information Not Available
Find out what your peers are saying about Microsoft Analytics Platform System vs. SAP BW4HANA and other solutions. Updated: August 2026.
908,858 professionals have used our research since 2012.