SAP BI BW 7 .3

 

COURSE ID
GES-BI
DURATION 60 hrs
DELIVERY METHOD Classroom Instructor-led training (CILT)
Online Instructor-led training ( OILT)

COURSE OVERVIEW Non-Vocational Certification Program GES College of Information Technology provides training on SAP Business Intelligence.
COURSE OBJECTIVES

SAP Certification Preparation Training
The SAP Certification Preparation Training delivers the most popular techniques and skills for professional users. It is intended for individuals who already have experience in related fields and is offered for the purpose of upgrading or updating qualifications.

I . MODELING

Unit 1: The Multi-dimensional Model in SAP BI 7.3

Unit 2: Data Extraction and Data Flow within SAP BI 7.3 NW 2004S

Unit 3: New Data source Concept of BI 7.3

Unit 4: Transformation in BI 7.3(ETL)

Unit 5: DTP (Data Transfer Process)

Unit 6: UPGRADING DATAFLOWS FROM 3.X TO BI 7.3

Unit 7: Business Content

Unit 8: Administration of InfoCubes and Aggregates

Unit 9: DSO (DATA STORE OBJECTS)

Unit 10: Virtual Cubes and Multi Providers

Unit 11: New Enhancement of SAP BW 7.3

II. DATA EXTRACTIONS (ETL)

ECC Extractions Using BI 7.3 Dataflows

Unit 1: Overview of ECC6.0 Extractions.

Unit 2: Generic Extractions.

Unit 3: Business Content Extractions

Unit 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)

Unit 5: LO-COCK PIT Extractions (LOGISTICS)

Unit 6: FI-SL Extractions (Financial special purpose ledger)

SAP CRM Extractions.

Unit 7: Delta Management

Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)

Unit 9: Datasource Enhancement

Unit 10: Process Chains in Detail covering all process Types

Unit 11: Upgrading process Chains from 3.x to BI 7.3

Unit 12: APDS (Analysis Process Designers)

III. REPORTING

Unit 1: Introduction to BI Enterprise Reporting.

Unit 2: Navigating in Reports

Unit 3: First Steps in Query Designer

Unit 4: Key Figures

Unit 5: CHARACTERSTICS

Unit 6: Attributes

Unit 7: Exceptions and Conditions.

ADVANCED REPORTING Topics

Unit 8: RRI (report to report interface)
Unit 9: Bex Analyzer
Unit 10: Bex Web Analyzer
Unit 11: Overview of Information Broadcaster.
Unit 12: Web Reporting using new Web Application Designer
Unit 13: New Enhancement of SAP BW 7.3
Overview of Integrated Planning in BI 7.3 (IP)
Transporting Objects (CTO).
Unit 13: New Enhancement of SAP BW 7.3
Mini project: The student has to work on Complex dataflows given by the Instructor.
Main Project Will be given to the students once they finished the course

NEW ENHANCEMENTS OF SAP BW 7.3

UNIT 1: Hybrid provider

UNIT 2: New monitors in BW Administration cockpit

UNIT 3: Generic delta functionalities for further types of Data Sources

UNIT 4: Hierarchies

UNIT 5: Data Transfer Process (DTP)

UNIT 6: Open Hub Service

UNIT 7: Transformation

UNIT 8: SAP BODS (New ETL Tool of SAP) Integration

I. MODELING

Unit 1: The Multi-dimensional Model in SAP BI

The SAP BW Star Schema Concept

Data warehousing Workbench (DWB)

InfoObjects

InfoCubes

Unit 2: Data Extraction and Data Flow within SAP BI 7.3 NW 2004S

3.x Dataflow

Overview of BI 7.3 Dataflow

Comparison of 3.x and BI 7.3 Data flows

Loading Master Data (Attributes, Texts, Hierarchies)

Loading Transaction Data

Unit 3: New Data source Concept of BI 7.3

Overview of new Datasource

Emulation of Data source in BI 7.3

Datasource Lifecycle with In BI 7.3 NW 2004S

Migration of 3.x data source to BI 7.3 data source

Unit 4: Transformation in BI 7.3(ETL)

In depth coverage of Transformation

Routines in Transformations (Start routine, End routine, Expert routine, transformation routine) with different Real Time examples

Transformation Groups

Unit and currency Conversions

Unit 5: DTP (Data Transfer Process)

Overview of DTPS

Trouble shooting techniques in DTPS

Debugging ABAP routines Using DTPS

Unit 6: UPGRADING DATAFLOWS FROM 3.X TO BI 7.3

Unit 7: Business Content

Business Content (BCT)

Unit 8: Administration of InfoCubes and Aggregates

Managing Basic Cubes

Aggregates

BI Accelerators

Unit 9: DSO (DATA STORE OBJECTS)

Data Store Objects concept

Unit 10: Virtual Cubes and Multi Providers

Virtual Cubes

Multi Providers

Mini project: The student has to work on 5 dataflows given by the Instructor.

II. DATA EXTRACTIONS (ETL)

ECC extractions using BI 7.3 Data flows.

Unit 1: Overview of ECC6.0 Extractions.

Types of ECC extractions

Unit 2: Generic Extractions.

Generic Extraction using

Database Table view

Classical Info sets.

Functional Module.

Unit 3: Business Content Extractions

Overview of Business Content Extractions.

Examples from Financial, Logistics, HRMS modules.

Unit 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)

Unit 5: LO-COCK PIT Extractions (LOGISTICS)

Unit 6: FI-SL Extractions (Financial special purpose ledger)

SAP CRM extractions.

Marketing Extractions

CRM SALES Extractions

CRM SERVICE Extractions (CRM Extractions are Very High in demand)

Unit 7: Delta Management

Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)

Unit 9: Datasource Enhancement

Unit 10: Process Chains in Detail covering all process Types

Real time examples on process Chains (Meta Chains)

Unit 11: Upgrading process Chains from 3.x to BI 7.3

Unit 12: APDS (Analysis Process Designers)

III. REPORTING

Unit 1: Introduction to BI Enterprise Reporting.

The SAP BI Overview

Unit 2: Navigating in Reports

Unit 3: First Steps in Query Designer

Query Designer

Info providers in query Designer

Unit 4: Key Figures

Restricted Key Figures

Calculated Key Figures

Properties of Key Figures

Structures and cells

Unit 5: CHARACTERSTICS

Properties and Attributes of Characteristics

Integrating attributes and hierarchies in reports.

Unit 6: Attributes

Characteristic Variables

Hierarchy variables

Hierarchy Node variables

Formula Variables

Text variables

Variable Processing types.

Unit 7: Exceptions and Conditions.

Exceptions

Conditions

ADVANCED REPORTING Topics

Unit 8: RRI (report to report interface)

Unit 9: Bex Analyzer

Unit 10: Bex Web Analyzer

Unit 11: Overview of Information Broadcaster.

Unit 12: Web Reporting using new Web Application Designer

In depth of Web reporting using New Web Application Designer,

Detail Coverage of Dash Board Reports and each and every Web item of new WAD.

Overview of Integrated Planning in BI 7.3 (IP)

Transporting Objects (CTO).

NEW ENHANCEMENTS OF SAP BW 7.3

UNIT 1: Hybrid provider

UNIT 2: New monitors in BW Administration cockpit

UNIT 3: Generic delta functionalities for further types of Data Sources

UNIT 4: Hierarchies

Integration of hierarchies into process flow (DTP, Transformation)

Remote hierarchies for direct access to hierarchies in the source system

Loading hierarchies from flat file using the new Data Source and Transformation technology

UNIT 5: Data Transfer Process (DTP)

Data Transfer Process supports data extraction from Multi Providers

Option to only load the last request from a given source (available for full load DTPs)

Data Transfer Process supports referential integrity checks tor navigational attributes of the target

Enhanced load performance by possibility to Re-package small data packages within a request to bigger packages

UNIT 6: Open Hub Service

SAP Net Weaver BW data can be exported in XML format

Possibility to change the format and length of BW data for export even into a non-SAP specific format
Hierarchy extraction supported by Open Hub

UNIT 7: Transformation

Semantic grouping possible in Transformations (in addition to semantic grouping in DTPs)

Possibility to select the Info Objects (fields) the user wants to use in a Start- / End routine

Currency and unit conversion for Data Store object and Info Source as target of a Transformation.

Navigation attributes of Info Cubes/Data Store objects can be used as source fields in the Transformation and as filter/select options in the DTP

Automated generation of a proposal by mapping fields of the Data Source to Info Objects

UNIT 8: SAP BODS (New ETL Tool of SAP) Integration

Recent comments

Martinez

"I thank Globalerp solutions for helping me to complete my SAP BI training. They have helped me in developing my ERP SAP skills."

Brown

"I have done SAP BI course from Globalerp solutions training institute. Extremely professional faculties and they are very pleasant with students.
"

Jennifer

"I am looking for a training on SAP BI, but in montreal, I got Globalerp solutions and now I am completely satisfied with my SAP BI training. "