Business Warehousing – Solutions by SAP

  • SAP BW – Business Warehousing – Solutions by SAP
  • Flexible analytical and reporting tool
  • Business data integrated, transformed and consolidated in SAP BI
    • SAP launched ‘BIW – Business information warehouse’ in 1997, version 1.2A
    • Name changed as ‘BW – Business warehouse’ with version 3.0A
    • Named ‘BI – Business intelligence’ with version 7.0
    • SAP BW 7.3 SP05 or higher – BW on HANA
    • SAP BW 7.5 SP04 or higher with HANA Database – BW/4HANA
  • Prerequisites
    • Primary sources: SAP ECC / S/4 HANA
    • Other sources: RDBMS/ Data Services/ Smart Data Access/ Web Services/ Files etc.

Key Functionalities

  • ETL ( Extraction, Transformation and Loading)
  • Data analysis, modeling and planning
  • Publishing content from SAP BI
  • Relational & Multidimensional Analysis
  • Current (according to update schedule) & Historical Analysis
  • Cross Functional
  • BW/4HANA Offers a simplified approach to modeling and multi-temperature architecture
  • BW/4HANA Offers an analytics manager for faster development of complex queries
  • The Business Explorer (BEx) is a component of SAP BI that provides flexible reporting and analysis tools that we can use for strategic analysis and supporting the decision-making process in an organization

Automatic’s SAP BW

  • SAP BW, BW on HANA and BW/4HANA – 7.X Implementation
  • Migration/Consolidation from SAP BW to BW on HANA and BW/4HANA
  • Migrate historical data from legacy systems
  • Provide post implementation support for an agreed upon amount of time
  • BW 7.X Technical Upgrade and Performance Tuning
    • This is a traditional upgrade where existing BW 3.x production system would be upgraded to BW 7.x by doing a copy of production and then upgrade
    • Provides short terms of post go-live support after the upgrade
  • SAP BW Upgrades from RDBS to HANA Platform
    • Assessment and planning
    • Landscape upgrade approach
    • Upgrades across versions
    • Business continuity and safeguarding
  • Roll out activities
  • Enterprise Reporting Strategy & Architecture
  • Standard Support

          Typical Data Flow in SAP BW, BW on HANA

  • SAPBusiness Warehouse (BW) integrates data from different sources, transforms and consolidates the data, does data cleansing, and storing of data as well. It also includes data modeling, administration and staging area.
  • The data in SAP BW is managed with the help of a centralized tool known as SAP BI Administration Workbench. The BI platform provides infrastructure and functions which include −
    • OLAP Processor
    • Metadata Repository
    • Process designer and other functions.

Let’s make something great together.