TrustRadius: an HG Insights company

SAP BW/4HANA

Score8 out of 10

77 Reviews and Ratings

What is SAP BW/4HANA?

Read more details.

Categories & Use Cases

Media

Screenshot of Next generation data warehousing with SAP BW/4HANA.
Screenshot of SAP BW/4HANA user cockpit.
Screenshot of Geolocation analytics in SAP BW/4HANA.
Screenshot of Data modeling in SAP BW/4HANA.
Screenshot of Modern user experience in SAP BW/4HANA.
Screenshot of Monitor the performance of your business in real-time with SAP BW/4HANA.

1 / 6

Screenshot of Next generation data warehousing with SAP BW/4HANA.

Top Performing Features

  • Multi-User Support (named login)

    Named model access means that users have access based on name and password.

    Category average: 9.4

  • Multiple Access Permission Levels (Create, Read, Delete)

    Multiple access permission levels means that different levels of users have different rights.

    Category average: 8.9

  • Single Sign-On (SSO)

    Allows users to use one set of login credentials to access multiple applications

    Category average: 9.4

Areas for Improvement

  • Administrative Automation

    The product’s capacity to automate administrative tasks such as patching, scaling, and creating backups.

    Category average: 6.9

  • Visualization

    The product’s support and tooling for analysis and visualization of data.

    Category average: 5.1

  • Self-Optimization

    The product’s capability to monitor and adjust internal metrics and systems to keep performance as high as possible.

    Category average: 6.6

Who Buys & Uses SAP BW/4HANA

BW/4HANA is a great tool for a number of use cases

Pros

  • Near real-time data replication from HANA databases.
  • Strong BW functionality.
  • A host of cloud reporting tools can seamlessly connect to it.

Cons

  • Enterprise license pricing is very expensive and run-time license limits the usefulness of the tool.
  • Integration with SAP Analytics cloud for write-back to BW/4HANA. Live connection is only read from SAC.
  • Make run-time licenses more useful.

Most Important Features

  • Seamless connectivity
  • Ease of use
  • Scalability

Return on Investment

  • Eliminates data interfaces and cumbersome reconciliation from our ERP systems.
  • Ability to replicate data in near real-time.
  • Ability to standardize on cloud-based reporting tools.

Alternatives Considered

Tableau Desktop, SAP Analytics Cloud, SAP BPC (Business Planning and Consolidation) and SAP BusinessObjects Business Intelligence (BI) Platform

Other Software Used

SAP S/4HANA, SAP Profitability and Performance Management, SAP Analytics Cloud

Usability

SAP BW/4HANA improves your business

Pros

  • SAP GUI
  • SAP HANA Designer
  • User interface
  • Integrations

Cons

  • Security
  • Optimizing queries
  • Workspace

Most Important Features

  • The fastest respond times over a lot of queries
  • Possibilities [for] growth in terms of accuracy in our reports
  • Fast queries
  • High performance

Return on Investment

  • Expensive investment
  • Fast queries
  • Get data near real time

Alternatives Considered

SAP IQ (formerly SAP Sybase IQ)

Other Software Used

SAP IQ (formerly SAP Sybase IQ), SAP HANA, SAP HANA Cloud

BW/4HANA very recommended for reporting on you SAP landscape

Use Cases and Deployment Scope

SAP BW/4HANA is primarily used in our organization as data aggregation for sales, finance and logistics reporting. This is used across different companies. In some instances is also used for planning features connected to our trade promotions management system. Data sources are mainly the ERP systems which are also SAP systems.

Pros

  • Integration with SAP Suite for data extraction
  • Solid knowledge base in consulting market
  • Prebuilt data model

Cons

  • Additional licensing to incorporate some data sources

Return on Investment

  • At implementation certainly helped gain financial visibility
  • Also once proper queries were built, reduced overall month end closing processes and preparation for financial reviews
  • Data integration with all SAP solutions is key

Alternatives Considered

Tableau Server

Other Software Used

SAP S/4HANA Cloud, SAP Signavio Process Transformation Suite, SAP Business Network

A comprehensive solution for enterprise data warehousing

Pros

  • Loading data from SAP ERP data sources.
  • Use of data virtualization to minimize load times.
  • Data hosting in memory since the underlying database is HANA.

Cons

  • Interface improvements so that all development is web-based.
  • Ease of connectivity with non-SAP sources.
  • Avoid the need to continue using the SAP GUI.

Return on Investment

  • Positive impact on the availability of information for decision making.
  • Avoid the need for multiple databases for isolated data warehouses within the organization.
  • Immediate availability of information for managers and business users.

Alternatives Considered

SAP Analytics Cloud and SAP Data Services

Other Software Used

SAP BPC (Business Planning and Consolidation), SAP Adaptive Server Enterprise, SAP Master Data Governance

A quick review on BW/4HANA from a techie's point of view

Use Cases and Deployment Scope

We use BW/4HANA for analytics and reporting. It is used across the enterprise. Our initial deployment has been across finance with a view to migrate our classical BW environment over to BW/4HANA. Our currently classical BW has reached end of life and we need to commence the migration over to BW/4HANA soon.

Pros

  • Better preformance
  • Ability to perform hybrid data modelling
  • Better integration to non-SAP data sources
  • Simplified data modelling

Cons

  • Still has reliance of ABAP stack.
  • Not all exception aggregation conditions are pushed down to HANA
  • BW-IP should be included in offering as it was previously.
  • BW workspaces could improved, has huge potential.

Return on Investment

  • Faster turn-around to enhancements
  • End users can query structures that are not limited to multi-dimensional models.
  • Performance improvements means that business user can do more in the same time compared to traditional BW

Other Software Used

SAP Business Warehouse, Microsoft SQL Server, Oracle Analytics Cloud