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.