SAP BW 7.3

This course will teach participants how to enable streamlined data modelling, automated semantic portioning and efficiently reduce redundant execution of planing function.

COURSE OBJECTIVE

LESSON PLANS


​SESSION 1: SAP DATA WAREHOUSING:
Session Goal
  • Introduction to Data Warehousing.
  • Father of Data Warehouse.
  • Definition of Data Warehousing.
  • Key functions of Data Warehousing.
  • Applications & Types of SAP.
  • Overview of SAP R/3 Types of Applications.
  • OLTP.
  • OLAP.
  • R/3 Architectures.
  • Landscape of SAP.
  • Transportation.
  • Package.
  • Request no.
  • Return codes.
  • Types of Data.
  • Master Data.
  • Transaction Data.
  • Master Data.
  • Attribute Data.
  • Text Data.
  • Hierarchy Data.
  • Transaction Data.
  • Header Data.
  • Item Data.
  • Scheduling Data.
  • Star Scheme Concepts.
  • Classical Star Schema (DW).
  • Extended star schema (BW).

​SESSION 2: SAP BW/BI INTRODUCTION
Session Goal
  • Introduction to SAP BW/BI.
  • History of SAP BW/BI.
  • Necessity of SAP BW/BI.

​SESSION 3: SAP BW/BI ARCHITECTURE
Session Goal
  • Source System & Target System.
  • Source system connections.
  • Data Modeling, Loading and Extraction.
  • Data Reporting.

​SESSION 4: SAP BW DATA MODELLING
Session Goal
  • Info area.
  • Info objects Catalog.
  • Info objects.
  • Info source.
  • Direct update.
  • Flexible update.
  • Data source.
  • Source system.
  • Application component.
  • Transfer rules.
  • Transfer structure.
  • Communication structure.
  • Info providers.
  • Data targets.
  • Info cubes.
  • Standard Info Cube.
  • Real-Time Info Cube.
  • ODS.
  • DSO.
  • Standard DSO.
  • DSO for Direct Update.
  • Write-optimize DSO.
  • Update rules.
  • Transformations.
  • DTP – Data Transfer Process.
  • Standard DTP.
  • Error DTP.
  • RDA DTP.
  • Direct DTP.
  • Info package.
  • Extract structure.
  • PSA.
  • Standard PSA.
  • Error Stack PSA.
  • Data Acquisition.
  • Standard.
  • Real Time.
  • Re-Modeling.
  • Re-partitioning.
  • APD – Analysis Process Design.
  • Visual Composer.
  • IP – Integrated Planning.

​SESSION 5: SAP BW DATA LOADING & SCHEDULING
Session Goal
  • Data loading using flat files.
  • Attribute data.
  • Text data.
  • Hierarchy data.
  • Transaction data.
  • Live concepts of using MDM.
  • Reusability of master data.
  • Designing the transfer rules, transfer structure and communication according to data using different Techniques Dynamic calculation, suppressing data & adding new functionality to the data of the transfer.
  • Rules and update rule level while loading data.
  • Handling data function while loading data.
  • BW Architecture.
  • PSA Maintenance.
  • Scheduling the data.
  • Data packet by data packet.
  • Complete data scheduling.
  • Scheduling in background.
  • Debugging the Data while loading.
  • Transfer rule level.
  • Update rule level.
  • PSA Processing types.
  • Terminating errors while loading the data.
  • Increasing the data packet size.
  • Application server file concept _AL11.
  • Scheduling the data in background.
  • Monitoring the data loading.
  • Scheduling the jobs based on periodic values.
  • Cancelling and deleting the background jobs.
  • ODS.
  • New data table.
  • Active data table.
  • Change log type.
  • ODS setting.
  • Automatic.
  • Manual.
  • Details.
  • 9 cases of deltas with real scenario.
  • Error handling in deltas.
  • Data Mart.
  • ODS – Info Cube.
  • Info Cube - Info Cube.
  • ODS–ODS.
  • Multi Providers.
  • Info set.
  • Partitioning.
  • Line items dimensions.
  • Performance issues.
  • Roll up.
  • Aggregate.
  • Collapse.
  • Reconstruction.
  • Deletion of data from data Targets.

  • Complete deletion of data.
  • Deleting data by request ID.
  • Selective deletions.
  • Process Chain​​.
  • Direct Schedule.
  • Meta chain.
  • Error handling in process chain.
  • Monitoring process chain.
  • Message integration.
  • Success.
  • Error.
  • Always.
  • Scheduling process chain based on Periodic values.
  • Cancelling the process chain jobs.
  • Rescheduling the process chain.
  • Folder creation for a specific process chain.
  • Creating a variant for ABAP programs and integrating in process chain.
  • ALE Remote jobs.
  • Attribute change run.

SESSION 6: SAP BW DATA EXTRACTION
Session Goal
  • Application Specific Extractors (BW Content Extractors & Customer Generated Extractors).
  • Cross Application Specific Extractors (Generic Extractors).
  • Flat files.
  • LOS.
  • LIS.
  • Generic Extraction.
  • Master data.
  • Transaction data.
  • CO-PA.
  • FI-SI.
  • DB connect.
  • Business content extraction.
  • Generic delta.
  • BW Data Source Enhancement.
  • Product Issues.
  • Ticket Handling.
  • Ticket tool tracker.
  • Error handling.

​SESSION 7: SAP BW DATA REPORTING
Session Goal
  • BEX Analyser.
  • BEX Browser.
  • BEX WAD.
  • BEX query designer.
  • Role maintains.
  • Creating a role.
  • Assigning a role.
  • Variables.
  • Types.
  • Represent.
  • Entry.
  • Process.
  • Conditions.
  • Formula.
  • Calculated Key Figures.
  • Restricted key figures.
  • Exceptions.
  • Filters.
  • Free characteristics.
  • Structures.
  • Cell definitions.
  • Query performance.
  • Brain Errors.
  • Forcing variables.
  • Information broadcasting.
  • Cache inactive.
  • Query Monitoring.
  • RRI (report-to-report interface).
  • Query properties.

​SESSION 8: SAP BW DATA TRANSPORTATION
Session Goal
  • System Landscape.
  • Transportation Landscape.
  • Overview of Transports.
  • Objects Collection in Transports.
  • Sequence of Transports Migration.
  • Transports Collection & Setting.
  • Transport Issues.
  • Assigning object to the requests.
  • Releasing the Request number and their Dependency.
  • Return code.
  • Mail drafting to basis team regarding transportation.
  • Searching objects locally and business.
  • Contents through Meta Data Repository.
  • Fact less Fact Tables.
  • SQVI-quick views.
  • Business content.
  • Definition.
  • Activation.
  • Open hub service.
  • Info spoke.

SESSION 9: SAP BW INTEGRATION
Session Goal
  • SAP BW Reports through Enterprise Portal.
  • SAP BW/BI – BO Integration.
  • SAP BW/BI With HANA.
  • SAP BW/BI with BPC.
  • SAP BW/BI with Legacy systems.
  • SAP BW/BI Batch Job Monitoring Tools.
  • Importance of SAP ABAP/4 & Basis in BW/BI.

​SESSION 10: SAP BW PERFORMANCE TUNING TECHNIQUES
Session Goal
  • Partitioning.
  • Compressions.
  • PSA Table Deletions.
  • BI Accelerator.

​SESSION 11: NEW ENHANCEMENTS OF SAP BW 7.3
Session Goal
  • Loading Hierarchies using BI 7.0 Data Source.
  • Generic delta functionalities for non - SAP Data Sources to extract data from non - SAP source systems.
  • Semantic Partitioning.
  • New monitors in BW Administration cockpit.
  • Generic delta functionalities for further types of Data Sources.
  • Open Hub Service.
  • Transformation.
  • Hybrid Info Provider.
  • Transformation Enhancements.
  • DTP Enhancements.
  • Multi Provider as a source.
  • Process Chain Enhancements.
  • Data Flow Wizard and Data Flow Copy tool.
  • Data Flow Migration Tool.
  • Enhancements to RDA.
  • Info package Enhancements.
  • SAP BODS (New ETL Tool of SAP) Integration.

​SESSION 12: SAP BW REAL TIME/PROJECT SCENARIOS
Session Goal
  • Production Support Issues.
  • Implementation Project Issues.
  • Migration/Up gradation Project Issues.
  • Batch Jobs Monitoring.
  • Ticket Handling.
  • Ticket tool tracker.
  • Error handling.
CASE STUDY AND PROJECTS
Case studies are integral part of training. As part of this course we will ensure you  implement Real-time Case studies ​in various domains which includes:
  • Banking.
  • Telecom
  • Ecommerce.
  • HealthCare.​
These case studies will be evaluated by domain experts and you would get an opportunity to get Feedback on the work.
TRAINING FEATURES
1) Extensive Real Time Live Examples, Projects & POCs for improved practical competency, ensure deployment readiness and implementation.
2) Custom Lab, Software and Environment provided with Real-time Project Simulation.
3) Recorded Videos complemented with corresponding lecture ppts, materials & lab guides. (Provided in the form of MP4 videos, pdf, ppt for offline access as well).
4) Certification and Job-Interview Counselling & Coaching after every training.