S4 SAP BW ON HANA

Business Warehouse (BW) is SAP’s data warehousing application; it uses an SAP NetWeaver application server, but can run on many different databases. Improvements come with each version of Courses for sap BW on HANA training, but a really big jump in functionality comes when SAP BW is installed on the SAP HANA database. Now, there are two flavors of SAP BW powered by SAP HANA: Courses for sap BW on HANA training powered by SAP HANA and SAP BW 7.5, edition for SAP HANA.

A person should have good experience in SAP BW with expert level knowledge of SAP BW on SAP HANA projects. He/she should have worked on projects involving SAP BW modeling with respect to SAP HANA using composite providers, Advance DSOs, ODP, LSA ++ and using BW objects exposed as HANA views

Oracle Courses

Course for SAP BW on HANA Details

Batch TypeOnline and Instructor Led Training
Duration2 months
Fees30,000
Enroll 

Syllabus for SAP BW on HANA

SAP BW ON HANA COURSE OVERVIEW

  • SAP BW on HANA is the next wave of SAP’s in-memory technology vision that enables SAP NetWeaver BW to use SAP HANA as a fully functioning in-memory database.
  • Running SAP BW on HANA results in dramatically improved performance, simplified administration and streamlined IT landscape resulting in a lower total cost of ownership.
  • SAP BW on HANA is nothing but SAP’s Existing database for the NetWeaver BW Data Warehouse.
  • Because SAP HAAN is much faster than regular relational databases like Oracle or Microsoft SQL Server, the data warehouse performs much faster.
  • The Purpose of SAP BW on HAAN is to combine the power of both.
SAP BW ON HANA BENEFITS
  • Excellent query performance for improved decision making.
  • Simplified data modeling and remodeling.
  • Faster decision making – Having the right information when you need it.
  • Lower total cost of ownership.
  • Simplified configuration and operational management.

SAP BW ON HANA 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:
  • 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 Object Catalogs
  • Info Objects
  • PSA
  • Info Area
  • Application Component
  • Info Source
  • Data Source
  • Transfer Rules
  • Update Rules
  • Transfer Structure
  • Communication Structure
  • Info Package
  • Transformation
  • 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 Courses for sap BW on HANA training
  • 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
  • Expert Routine

DTP (DATA TRANSFER PROCESS)

  • Standard DTP
  • Error DTP
  • Direct Access DTP
  • Real-time DTP

DSO (DATA STORE OBJECT)

  • Standard DSO
  • Write optimized DSO
  • Direct update DSO
  • APD (Analysis Process & Design)
  • Update Methods
  • Full updates
  • Initialization
  • Delta Updates

INFO PROVIDERS

  • Multi Providers
  • Info set
  • Virtual Providers
  • Re-Modeling
  • Re-Partitioning
  • Open-Hub Destination
  • Data Marts

REPORTING – BUSINESS EXPLORER

  • BEX Query designer
  • 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
  • Structures
  • Variable Definition in Detail
  • Characteristic values variables
  • Text Variables
  • Formula Variables
  • Hierarchy Variable
  • BEX Analyzer
  • BEX WAD

ANALYSIS FUNCTIONS

  • Conditions
  • Exceptions
  • Reporting Drilldown
  • Drill down 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
  • Business Content Extractions using MD/TD
  • LO-COCKPIT Data Extraction
  • Delta types for Generic Extraction
  • LO Extraction
  • ASAP methodology
Courses for sap BW on HANA training with real-time IT expert.
Summary
Review Date
Reviewed Item
S4 SAP BW on HANA
Author Rating
51star1star1star1star1star