• Home
  • Courses
  • Videos
  • Blog
  • Corporate
  • Contact Us

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.
ALCHEMY LEARNSOFT
Courses
Videos
Blog
Corporate
CONTACT US
​support@alchemyls.com
​1800-929-7190​
ADDRESS
​​2711, Centerville Road
Suite 400

Wilmington, DE 19808
© 2016 Alchemy LearnSoft. All Rights Reserved.