+91 6300698155 | | +91 6300698155 | erplearninghub123@gmail.com

SAP BW4HANA Introduction

SAP Business Warehouse (BW) powered by SAP HANA refers to using BW software suite on top of HANA database. This functionality explores all the key features of HANA database technologies and uses BW as a modeling tool for data modeling and analytical reporting. BW software supports various databases like Oracle, Microsoft, IBM DB2, Teradata, and many more. BW on HANA suggests that you are using HANA as database for BW data modeling capabilities and no other database is required.


you have the knowledge on BW and HANA concepts, like DataStore Objects (DSO), Data Transformations, InfoCubes, Query optimization, HANA Modeling and HANA DB features using HANA Studio. If you are not aware of these concepts, then we recommend that you first go through above concepts.

SAP Business Warehouse (BW) powered by SAP HANA helps you speed up data analysis by consuming data via a Data Warehouse (DW) for analytical reporting and data analysis. You can achieve key opportunities like real-time data integration and data modeling, and hence real-time BI reporting on large amount of data in the database.

SAP Business Warehouse continues to act like a powerful data warehouse tool to consolidate master data and provide flexible reporting options. With SAP HANA underneath BW system as a database, you can use a combination of DW capabilities with fast in-memory database to achieve performance improvements and exceptional modeling capabilities.

HANA in-memory database is much faster as compared to other common databases like Oracle, SQL Server, and hence DW performs much faster when powered by HANA as database underneath it. It combines the power of both the tools - BW Modeling and HANA in-memory computing engine to process huge amounts of data

SAP BW/4 HANA includes a preconfigured set of application specific data models for selected business areas and industries. It does this in a simpler fashion than the traditional SAP BW architecture due to the technology improvements made by SAP as part of the underlying HANA platform. This Business Content enables quick and cost-effective implementation providing a model that can be used as a guideline during implementation avoiding a great deal of bespoke development. The model can:

For any SAP ERP customer without a data warehouse, now is the time to consider deployment of this new capability because of the more simplified architecture and overall solution. In essence, the business content enables rapid deployment and delivery of data so a business can focus on generating insight through their business intelligence (BI) technologies.

SAP HANA studio is an Eclipse-based tool that runs on development environment and administration tool for working on HANA.

SAP HANA studio is both the central development environment and the main administration tool for HANA system. It is a client tool which can be used to access local or remote HANA system.

It provides an environment for HANA Administration, HANA Information Modeling and Data Provisioning in HANA database.

SAP BW4HANA Online Training Course Content

  • Overview of the SAP BW in Hana
  • Module One: Enterprise Structure Introduction to ERP
  • SAP, Data Warehouse Overview of BW, BI, Data Base
  • Overview of BW Architecture, Landscape Basic Modeling
  • System Monitor - SAP BW4HANA Online Training
  • Create a valid Schema Multi-Dimensional Model – The Star Schema (Classical Approach) Multi-Dimensional Star Schema in BW (Extended star Schema) The OLAP Concept
  • Differences between OLAP and OLTP Business Modeling
  • Info Area
  • Info Object Catalogs
  • Info Objects
  • PSA - SAP BW4HANA Online Training
  • Application Component
  • Info Source
  • Data Source
  • Transfer Rules
  • Update Rules
  • Transfer Structure
  • Communication Structure
  • Info Package
  • Transformation - SAP BW4HANA Online Training
  • Data Transfer Process
  • Loading Transactional Data into BW info Cube Loading MD
  • with TD into BW System BW and BI Comparisons Master data loading-new(BI) ETL process
  • Info cube & Types
  • Standard Info cube and Loading with new ETL Process
  • Generate Report with BI master and Transaction Data
  • Manual Uploading of MD like Attributes, Text, Hierarchy
  • Different Types of Attributes Transformations
  • Rule types Routines
  • Start Routine
  • End Routine - SAP BW4HANA Online Training
  • Expert Routine
  • DTP (Data Transfer Process)
  • Standard DTP
  • Error DTP - SAP BW4HANA Online Training
  • Direct Access DTP
  • Real time DTP
  • DSO (Data Store Object)
  • Standard DSO
  • Write optimized DSO
  • Direct update DSO
  • APD (Analysis Process & Design)
  • Update Methods - SAP BW4HANA Online Training
  • Full updates
  • Initialization
  • Delta Updates
  • Info Providers
  • Multi Providers
  • Info set
  • Virtual Providers
  • Re-Modeling - SAP BW4HANA Online Training
  • Re-Partitioning
  • Open-Hub Destination
  • Data Marts
  • Info Cube Maintenance
  • Aggregates
  • Roll-up - SAP BW4HANA Online Training
  • Compression
  • Reconstruction
  • Process Management
  • Process Chains, Process Types
  • Scheduling - SAP BW4HANA Online Training
  • Monitor (Header, Status, Details)
  • Reporting - Business Explorer
  • BEX Query designer
  • BEX Analyzer
  • BEX WAD - SAP BW4HANA Online Training
  • BEX Report Designer
  • Visual Composer
  • Functional Overview of Bex Query
  • Designer Reusable Query Elements
  • Query Controls with Variables
  • Calculated Key Figures
  • Restricted Key Figures
  • Formulae - SAP BW4HANA Online Training
  • Structures
  • Variable Definition in Detail
  • Characteristic values variables
  • Text Variables
  • Formula Variables
  • Hierarchy Variable
  • Analysis Functions
  • Conditions
  • Exceptions - SAP BW4HANA Online Training
  • Reporting Drill down
  • Drilldown to DSO from Info Cube (RRI)
  • Copying Queries from Cubes
  • Bex Analyzer Bex WAD Bex Report Designer
  • Visual Composer Migration Objects from BW 3.x to BI 7.0
  • Transportation Extraction
  • Generic Data Extraction using MD/TD Tables
  • COPA Extraction - SAP BW4HANA Online Training
  • Business Content Extractions using MD/TD
  • LO-COCKPIT Data Extraction
  • Delta types for
  • Generic Extraction
  • LO Extraction
  • ASAP methodology

Request For a Free Demo