SAP BW WITH HANA

SAP BW WITH HANA

SAP BW WITH HANA ONLINE TRAINING

  •    Rating
  •   Duration 35-40 Hours
  •      Fee $ 450

Request Free Demo

SAP BW WITH HANA TRAINING VIDEOS

  •    Rating
  •   Duration 30 Hours
  •      Fee $ 350

Buy Now



What Is SAP BW With HANA Training-

SAP BW on HANA is nothing but SAP's existing NetWeaver BW data warehouse, running on SAP HANA. 
SAP now supports SAP HANA as the underlying database for the NetWeaver BW Data Warehouse. Because SAP HANA 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 HANA is to combine the power of both.

SAP BW With HANA Course Content

Week-1

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

Info Object Catalogs

Info Objects

PSA

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

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

Week-2

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

Week-3

Info Cube Maintenance

Aggregates

Roll-up

Compression

Reconstruction

Process Management

Process Chains, Process Types

Scheduling

Monitor (Header, Status, Details)

Reporting – Business Explorer

BEX Query designer

BEX Analyzer

BEX WAD

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

Week-4

Analysis Functions

Conditions

Exceptions

Reporting Drilldown

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

Business Content Extractions using MD/TD

LO-COCKPIT Data Extraction

Delta types for

Generic Extraction

LO Extraction

ASAP methodology

Quick Enquiry