+91 6300698155 | +1 929-268-1172 | +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.

Prerequisites

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 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