Skip to main content
TrustRadius
SAP BW

SAP BW
Formerly SAP NetWeaver Business Warehouse

Overview

What is SAP BW?

SAP Business Warehouse, or SAP BW (formerly SAP NetWeaver Business Warehouse) is SAP's legacy data warehouse solution, now superseded by SAP BW/4HANA, and the SAP Data Warehouse Cloud which was launched in 2019. SAP BW versions up to 7.4 have reached…

Read more

Learn from top reviewers

BW Review

Rating: 8 out of 10
March 22, 2024
IncentivizedVetted ReviewVerified User
It is the core of all of our reporting. We have been using BW for around 15 years and our business couldn't run with out the product. We connect BW to all of our SAP systems i...
Continue reading
Andy Dahmus
Employee - Information Technology
Developer
Cintas
SAP Business Warehouse10 years of experience

SAP Business Warehouse, a gamechanger on traditional SAP ecosystem

Rating: 10 out of 10
February 5, 2024
IncentivizedVetted ReviewVerified User
SAP Business Warehouse is absolutely essential in the SAP ecosystem as it provides seamless integration of data from ERP (enterprise resource planning) modules in a standardiz...
Continue reading
Juan Carlos Crespo Rojas
Consultant - Professional Services
Senior SAP Consultant
Syntax
SAP Business Warehouse15 years of experience

One Stop Solution for All Modeling Needs of company for Operational & MIS Reporting

Rating: 7 out of 10
January 4, 2024
IncentivizedVetted Review
For Regular Operation & Analytical Purpose We use SAP BW. It has capability to provide Formatted Reports for business uses using Bex Analysis which is Front end Designing ...
Continue reading
Parijatam S
Consultant - Information Technology
Lead Consultant
Invenio Business Solutions
SAP Business Warehouse13 years of experience

Integrated warehouse management system

Rating: 9 out of 10
June 9, 2021
IncentivizedVetted ReviewVerified User
Our company provides smart solutions to our clients, this is one such solution for our customers, we use this solution primarily for data warehousing and reporting. They parti...
Continue reading
Niloofar Keshvari Nia
Administrative Assistant - Information Technology
IT Operations and Support Specialist
AZEREX LLC.
SAP Business Warehouse1 year of experience

High priced but with good consultants, implementation and base case uses

Rating: 7 out of 10
November 23, 2018
IncentivizedVetted ReviewVerified User
SAP Business Warehouse ("SAP BW") is used to aggregate data from disparate systems to create a single version of the truth or run reports / analyses across the entire organiza...
Continue reading
Jeff Looby, CPA
Professional - Other
Associate
Credit Suisse
SAP Business Warehouse1 year of experience
Log in with LinkedIn to see content from your network

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing
SAP BW

SAP BW

N/A
Unavailable

What is SAP BW?

SAP Business Warehouse, or SAP BW (formerly SAP NetWeaver Business Warehouse) is SAP's legacy data warehouse solution, now superseded by SAP BW/4HANA, and the SAP Data Warehouse Cloud which was launched in 2019. SAP BW versions up to 7.4 have reached end of maintenance. SAP BW 7.5 support is…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

19 people also want pricing

Alternatives Pricing

Db2

Db2

Free
What is Db2?

DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

ClicData

ClicData

$79
per month
What is ClicData?

ClicData is a 100% cloud-based business intelligence platform that allows users to connect, process, blend, visualize and share data from a single place. As an automated platform, users are able to rely on the latest version of company data, to ensure users make the right decisions. Hundreds of…

Return to navigation

Product Details

What is SAP BW?

SAP Business Warehouse (formerly SAP NetWeaver Business Warehouse) is SAP's legacy data warehouse solution, now superseded by SAP BW/4HANA.

SAP BW Competitors

SAP BW Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

SAP Business Warehouse, or SAP BW (formerly SAP NetWeaver Business Warehouse) is SAP's legacy data warehouse solution, now superseded by SAP BW/4HANA, and the SAP Data Warehouse Cloud which was launched in 2019. SAP BW versions up to 7.4 have reached end of maintenance. SAP BW 7.5 support is extended to align with SAP Business Suite with NetWeaver components. For existing customers maintenance is scheduled to continue through 2027, with extended support available through 2030.

Mycroft Assistant are common alternatives for SAP BW.

Reviewers rate Multi-User Support (named login) and Single Sign-On (SSO) highest, with a score of 9.7.

The most common users of SAP BW are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 14)

BW Review

Rating: 8 out of 10
Incentivized
March 22, 2024
AD
Andy Dahmus
Developer
Cintas (Consumer Services, 10,001+ employees)
Vetted Review
Verified User
SAP Business Warehouse
10 years of experience
Use Cases and Deployment Scope
It is the core of all of our reporting. We have been using BW for around 15 years and our business couldn't run with out the product. We connect BW to all of our SAP systems including CRM, ECC, MDG in order to get a full picture of our company and how we can inovate.
Pros
  • Integrates data
  • Solid Security
  • Mature product where users are comfortable
Cons
  • More native connectivity to other sets of data
  • push more things down to the DB
Likelihood to Recommend
While it does have some limitations, it is an extremely solid product.

SAP Business Warehouse, a gamechanger on traditional SAP ecosystem

Rating: 10 out of 10
Incentivized
February 05, 2024
Use Cases and Deployment Scope
SAP Business Warehouse is absolutely essential in the SAP ecosystem as it provides seamless integration of data from ERP (enterprise resource planning) modules in a standardized manner. Additionally, it offers the flexibility to customize as per specific business requirements, making it an indispensable tool for any organization.
Pros
  • SAP ERP modules can be integrated with SAP data using standard extractors, reducing time for new deliverables.
  • Transform the raw data into in insights.
  • Mature knowledge base.
Cons
  • Cloud integration is limited or restricted in some business scenarios.
  • Seems close the end of the software lifecycle, maintenance.
  • Sometimes, ABAP (Advanced Business Application Programming) expertise is required.
  • No IA capabilities.
Likelihood to Recommend
Using SAP ERP as the primary data source can speed up Business Intelligence deployments with pre-built objects, extractors, data flows, cubes, and queries. It also provides a way to consume data with both SAP and non-SAP Business Intelligence tools. Additionally, it allows for the addition of new features and applications on top of the SAP Business Warehouse backend, such as SAP Business Planning and Consolidation. providing not only a strong data warehouse repository but also a financial application in a single box.

One Stop Solution for All Modeling Needs of company for Operational & MIS Reporting

Rating: 7 out of 10
Incentivized
January 04, 2024
PS
Parijatam S
Lead Consultant
Invenio Business Solutions (Information Technology & Services, 1001-5000 employees)
Vetted Review
Reseller
SAP Business Warehouse
13 years of experience
View profile
Use Cases and Deployment Scope
For Regular Operation & Analytical Purpose We use SAP BW. It has capability to provide Formatted Reports for business uses using Bex Analysis which is Front end Designing tool. Business Modelling takes time but once done properly it provides very robust integration in terms master data & hierarchy access for reporting flexibility. Accessing attributes & grand attributes also comes handy with proper handling and with minimal effort at reporting levels. With the Onset of Composite Provider implementing Joins has become very easy. We can always create Calculated & restricted Measures & Dimension at Composite provider level with out consuming any permanent memory along with a great performance when HANA is backend
Pros
  • Integrations with SAP Source Systems
  • Complex Hierarchies can be handled easily in BW with help of BW
  • Master data attributes/ text once configured properly can be looked up in easiest way with least effort in any report.
  • Efficient Delta Loading mechanism and easy reconciliation of data
  • Connections to other Third Part Systems & File Systems
  • Taking data out from BW is also easy.
Cons
  • Advance Analytics like Regression & Classification Problems Use Cases not possible as of now in BW
  • Dashboarding Capabilities are not that great in BW Front End Tool
  • Self Ad-hoc reporting is not very flexible as its complex tool in design
Likelihood to Recommend
Now with Advent of B4HANA we should prefer B4HANA over BW. If budget is constraint BW is still superb tool with great capabilities. It is one of the tool with all capabilities of ETL, Modelling & Reporting. We can say that its a Super which alone is sufficient to cater need of any large/mid cap company.

Integrated warehouse management system

Rating: 9 out of 10
Incentivized
June 09, 2021
NK
Niloofar Keshvari Nia
IT Operations and Support Specialist
AZEREX LLC. (Information Technology & Services, 1-10 employees)
Vetted Review
Verified User
SAP Business Warehouse
1 year of experience
View profile
Use Cases and Deployment Scope
Our company provides smart solutions to our clients, this is one such solution for our customers, we use this solution primarily for data warehousing and reporting. They particularly appreciate its speed and ability to use a HANA database. It would be helpful to hear more about the vendor's strategy for the cloud solution.
Pros
  • Maintaining SAP BW is much easier than similar products
  • Powerful and extensive functionality
Cons
  • The system doesn't integrate well with other systems and is difficult to use
  • It would be beneficial to have reports that could be modified and saved more easily
  • You may find it difficult to build your type of report, many of the sections can be streamlined and easier to use
Likelihood to Recommend
SAP Business Warehouse allows us to run reports fast and accurately, allowing us to gain an understanding of our business, besides its built-in semantic data management models, it offers ease of use with a variety of data management systems, as well as data input by XML and other data sources.

High priced but with good consultants, implementation and base case uses

Rating: 7 out of 10
Incentivized
November 23, 2018
Use Cases and Deployment Scope
SAP Business Warehouse ("SAP BW") is used to aggregate data from disparate systems to create a single version of the truth or run reports / analyses across the entire organization. It is only used by the corporate team as each of the business divisions are extremely loyal to their specific software packages that are pulled into SAP BW (CRM, sales data, etc.).

The most important business problems that are solved is (1) the ability to produce more sophisticated analysis to drive executive decision making and (2) compile certain regulatory reports that are extremely time-consuming if produced outside of a data warehouse.
Pros
  • Integrates, stores, and manages company data from all sources
  • Pre-configured information models are better than average
  • Security authorization protocols and flexibility
  • Integration capabilities
Cons
  • Certain pruning can only take place on metadata rather than posted data
  • High runtimes for query execution
  • Results still requires fairly significant data verification time and effort
  • Infocube requires significant optimization efforts
Likelihood to Recommend
SAP BW is best for:

1. Large enterprises
2. Enterprises with 3+ legacy systems with entrenched users (politically difficult to merge)
3. Enterprises with employees who can understand both the technical capabilities of SAP BW and the needs of the business users - ability to speak both languages, otherwise the program could be unwieldy and potentially underutilized (it's not particularly inexpensive)

SAP BW is less appropriate for:

1. Small enterprises
2. Enterprises who have well established, same location, CRM and UFS - the integration of data analysis will be easier and less expensive with other solutions
3. HANA

Return to navigation