SAP BW HANA

 We provide the best SAP BW on HANA online training. The demand for BW on HANA professionals increases rapidly for last five years. So, we brought you the best BW on HANA training from industry experts. At Aurora, we have all the real-time experts. This makes you enhance you career opportunities in SAP BW , BW on HANA technology areas.

SAP BW on HANA online training

Like many other we don’t say, “we are the best in this…and that bla..bla “. Just make this simple and straightforward.

  1. Real – time training experience- In our SAP Business Intelligence training program we make you learn the things as it is what is there in live environment.
  2. Recording sessions of class- After completion of each live class, we provide the recording sessions. So, you can use it for forever in your lifetime as SAP business warehouse tutorials.

SAP BW on HANA online training course content:

Introduction to SAP HANA

  • HANA Architecture
  • HANA Use cases
  • HANA Studio

HANA DATABASE CONCEPTS

  • Schema
  • Database Tables (Row & column store)
  • Database View
  • Synonyms, Triggers, Sequences,UDF

STORED PROCEDURES

  • Simple stored procedures
  • Table Types
  • Column Views

BASIC SQL

  • Looping Statements, Conditional statements
  • Arrays, Using cursor, Using Temp & Tabletypes
  • Stored Procedures with column views
  • Using SQL, CE Functions
  • Debugging Stored Procedures

HANA MODELLING

Introduction

Different types of joins (Innner join, left outer join, right outer join,referential text, temporal, spatial)

ATTRIBUTE VIEW

  • Standard Attribute view
  • Time based attribute view
  • Derived attribute view
  • Creating calculated column
  • Creating hierarchies in attribute views
  • dynamic filter using input Parameters
  • Enabling attributes view for time travel queries

ANALYTICAL VIEW

  • Star join node
  • Creating calculated columns & measures
  • Restricted Columns
  • Counter
  • Input parameters
  • Variables
  • Semantics
  • Analytical View Properties
  • Focusing on temporal join in Analytical view
  • Mapping of input parameters

CALCULATION VIEW

  • Calculation view properties
  • SQL scripted Based & Graphical Mode
  • Aggregation
  • Projection
  • Union
  • Join
  • Rank
  • Dynamic join
  • Keep, Flag property
  • Transparent filter property
  • Star join node
  • calculates Columns & Measures
  •  Restricted columns
  • Counter
  • Input parameters
  • Variables
  • Semantics
  • Extract semantics
  • Creating Hierarchies in calculation view
  • Processing of HANA models

DECISION TABLES

  • Updating, What if Analysis

TEXT ANALYSIS

  • Processing of unstructured data, Full text index, using configuration and semantic analysis.

REPORTING ON SAP HANA

  • SAP LUMIRA
  • Design studio

DATA PROVISIONING

  • BODS, SLT, DXC, Flat file imports, smart data access

IMPORTING & EXPORTING OF HANA OBJECTS

HANA DEVLOPMETS

  • (How to devlop simple .XS project to build web based interfaces using SAPUI5, Reading data from database, Inserting data into database)
  • BW Powered by HANA
  • Optimized info cube, DSO, Transient provider, Consuming HANA models in SAP BW.
  • Importing BW objects into SAP HANA
  • Operational data provisioning using sources ECC,SLT,HANA Views.
  • LSA++,Advanced DSO,Open ODS view
  • Composite Provider
  • HANA Transformation
  • ABAP managed DB procedures
  • Near Line storage
  • BW workspace
  • Semantic partitioned objects

ECC Powered by HANA

  • ODP, HANA LIVE(VDM)

Where we are ?

We are on online, we offer this SAP BW online training for people across the world. We had taught people in US, UK, London, Canada, India,singapore,netherlands , washington, Hyderabad, bangalore, malaysia and many other countries/cities.