SAP BW

40,000.00

Category:

Mode of Training

LIVE ONLINE TRAINING

Curriculum

MODELING

The Multi-dimensional Model in SAP BW

 

  • The SAP BW Star Schema Concept
  • Data warehousing Workbench (DWB)
  • Info Objects
  • Info Cubes

 

Data Extraction and Data Flow within SAP BW 7.4 NW 2004S

  • 3.x Dataflow
  • Overview of BW 7.4 Dataflow
  • Comparison of 3.x and BW 7.34 Data flows
  • Loading Master Data (Attributes, Texts, Hierarchies)
  • Loading Transaction Data

New Data source Concept of BW 7.4

  • Overview of new Datasource
  • Emulation of Data source in BW 7.4
  • Datasource Lifecycle with In BW 7.4 NW 2004S
  • Migration of 3.x data source to BW 7.4 data source

Transformation in BW 7.4(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

DTP (Data Transfer Process)

  • Overview of DTPS
  • Trouble shooting techniques in DTPS
  • Debugging ABAP routines Using DTPS

UPGRADING DATAFLOWS FROM 3.X TO BW 7.4

Business Content

  • Business Content (BCT)

Administration of InfoCubes and Aggregates

  • Managing Basic Cubes
  • Aggregates
  • BI Accelerators

DSO (DATA STORE OBJECTS)

  • Data Store Objects concept

Virtual Cubes and Multi Providers

  • Virtual Cubes
  • Multi Providers

DATA EXTRACTIONS (ETL)

ECC extractions using BW 7.4 Data flows

Overview of ECC6.0 Extractions

  • Types of ECC extractions

Generic Extractions.

  • Generic Extraction using
  • Database Table
  • View
  • Classical Info sets.
  • Functional Module.

Business Content Extractions

  • Overview of Business Content Extractions.
  • Examples from Financial, Logistics, HRMS modules.

CO-PA Extractions (COST PROFITABLE ANALYSIS)

LO-COCK PIT Extractions (LOGISTICS)

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)

Delta Management

Extracting Master Data from CC (Attributes, Text, Hierarchies)

Datasource Enhancement

Process Chains in Detail covering all process Types

  • Real time examples on process Chains (Meta Chains)

Upgrading process Chains from 3.x to BI 7.3

APDS (Analysis Process Designers)

REPORTING

Introduction to BI Enterprise Reporting.

  • The SAP BI Overview

Navigating in Reports

First Steps in Query Designer

  • Query Designer
  • Info providers in query Designer

Key Figures

  • Restricted Key Figures
  • Calculated Key Figures
  • Properties of Key Figures
  • Structures and cells

CHARACTERSTICS

  • Properties and Attributes of Characteristics
  • Integrating attributes and hierarchies in reports.

Attributes

  • Characteristic Variables
  • Hierarchy variables
  • Hierarchy Node variables
  • Formula Variables
  • Text variables
  • Variable Processing types.

Exceptions and Conditions

  • Exceptions
  • Conditions

Benefits of Certificate

Skill Development: Certificates often require participants to acquire and demonstrate specific skills and knowledge. This can lead to improved competence and expertise in a particular area.

Career Advancement: Many certificates are directly related to specific careers or industries. Earning a relevant certificate can enhance your qualifications and make you a more attractive candidate for job opportunities or promotions.

Professional Recognition: Certain certificates are widely recognized and respected in specific fields. Earning such certificates can enhance your professional credibility and reputation.

Specialization: Certificates allow individuals to specialize in a particular area or aspect of a field, enabling them to focus on their areas of interest or expertise.