SAP System overview

• What is ERP? Different business modules of ERP.
• Two-dimensional tables.
• Master data and Transaction data.
• BW Overview
• Star Schema Concepts
• Multidimensional modeling.
• OLTP Vs OLAP.
• Data Warehousing in BW

Datawarehousing workbench

• Creation of Info area, Info object catalogs, Info objects, and attributes.
• Maintain master data.
• Creation of source system (Flat file).
• Creation of data sources, transformations, DTPs, and info packages (basic).
• Loading master data from a flat-file into an info object.
• Creation of basic cube and loading transaction data into info cube.
• Monitoring data after the load triggered.
• Concepts in basic modeling 

• Creation of a simple DSO and loading transaction data into DSO.
• Datamart concepts – Loading data from DSO to cube.
• Types of attributes – Display, Navigational, compounding, and Transitive.
• Attribute change run to activate master data.
• Transformation rules – writing start routine, end routines (ABAP), and transformation rule groups.
• Delta mechanism in BW.
• DTP concepts in detail – Types of DTPs, delta add-ins in DTP.
• Understanding the aggregation behavior of key figures in a basic report.
• Data Extraction from Source Systems

Data Extraction overview

• SAP R3 business process overview of Sales, purchasing and MM.
• The extraction process
• Types of extractors
• Logistics data extraction
• What is meant by logistics? Business areas of LO cockpit.
• Configuring of datasource, setup table filling and delta queue management.
• Different types of delta update methods – Queued, V3 serialized and direct.
• Process of Inventory data extraction with marker updates.
• Generic data extraction
• Creation of Data sources for master data and transaction data.
• Creation of master data based on table, view, infosets and Function module.
• Concepts of generic delta.
• Data sources for classification data (special features).
• Controlling and FI data extraction

Installing and activating business content Datasources

• Delta procedures
• Safety interval features
• Enhancing a data source
• Enhancing data sources for master and transaction data.
• Basic overview ABAP coding to write the code for enhancement.
• Extraction from Oracle Database
• Setting up ODBC connection to oracle DB
• TOAD or SQL Developer tool overview
• Reporting

Introduction to reporting tools

• BEx Query designer,
• BEx Analyzer,
• BO Web intelligence
• BO Dashboard designer.
• Getting started with Query designer
• Rows, columns, free Chars, default values and Filters.
• Properties of Query, char and key figure in BEx.
• What is drill down and navigational analysis?
• Data restrictions of char at different places in query designer.
• Creation and usage of the following objects.
• Calculate key figures, restricted key figures, New Selection, New Formula

Conditions, Exceptions, Structures

• Variables – different types of variables with processing types and their usage in real time
• BEx Analyzer
• Creating templates with different formatting items.
• Integrating templates in the workbooks.
• Creating Query views.
• Broadcast the reports using Information broadcasting feature.
• Complex Report requirements
• How to get the Count of document using formula with replacement path option.
• Designing Report to report interface for detailed level analysis of queries.
• How to work with Exception aggregation effectively.
• Writing the Customer exit variable code in CMOD to calculate YTD, YTM and importance of i_step1 and i_step2.
• Creating input-ready query on aggregation levels and enter plan data manually.
• Business Objects Web Intelligence

• BI launchpad
• Creating an BEx universe
• Creating a Webi document and query
• Navigations and reporting features.
• Dashboard Designer
• Creating a dashboard on BEx query
• Creating a dashboard on flat file data
• Dashboard on BO Webi data

Administration and Performance

• Creation of Hierarchies and loading hierarchy from a flat file.
• Types of DSO and Types of Info cubes.
• Multi-provider and Infoset.
• Business Content Installation.
• Transport Connection – Transport request sequence and resolving errors.
• Query Performance techniques.
• Compression, Partition, Index creation, Aggregates – Rollup
• Load performance techniques.
• Deleting index and Usage of background process effectively.
• Open Hub service – Retracting data from BW into the File system and other DB external systems.
• Currency Conversion and Quantity Conversion in Real-time

Obtaining any SAP certification is a boost for your career success and a valuable credential in any competitive career market.

If you are,

• a professional working with SAP products who wants to improve your SAP skills,
• a company who wants to use SAP products to streamline your business processes,
• a novice looking to add a highly recognised credential to your professional skills,

SAP training with SAP Training London is for you!

Our instructors are highly skilled with industry experience of  many  years, working in a best and renowned organization. Our Trainers follow an approach to engage students during instruction and thus the training methods are modified as per the trainees’ needs which may include direct 1-1 discussions, group discussions, Q&A rounds etc.  Also, you get many more advantages along with a highly professional approach.

• Flexible course timing to suit you
• Offer highly competitive course prices
• You will get Certificate of completion at the end of course
• We are centrally located and have good access from all corners of London
• We offer  Hands on training with lab access
• Small group training approach is followed, up to 5