SAP BW ON HANA

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

 

Rule types

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

 

Info Cube Maintenance

Aggregates Roll-up

Compression

Reconstruction

 

Process

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

 

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