SAP BW & BW4HANA Content

• SAP Introduction
• ERP
• System landscape
• SAP Client & System connection details
• OLAP vs OLTP
• SAP Architecture
• BI/BW Architecture
• SAP naming convention
• BI Data model overview
• Source system details
  -SAP
  -Non SAP Source Systems
• Application component
• Master data
  -Attributes
  -Text data
  -Creation
  -Tables
  -Naming conventions
  -IO as info provider
  -Naming conventions
  -Hierarchy and creation -SIDs
• Flat file data sources
  - File source system creation
  - Attributes data source creation
  - Text data source creation
  - Transaction data source
  - PSA data modifications
• SAP data sources
• Compounding InfoObject
• Reference and template infoobject
• Transformations & Rule types
• Data Transfer Process
• Harmonized infosource
• Outbound infosource
• Inbound infosource
• Info cube
  - Star Schema
  - Extended star schema
  - Info Cube introduction
  - Info cubes types
  - Info cube creation
  - Info cube tables
  - Example for info cube functionality
  - Line item dimension
  - High cardinality
  - Performance tuning
  - Compression o With Zero Eliminator
  - Marker update o No-marker update
  - Aggregation
• Data Store Object (DSO)
  - Types of DSO
  - SID generation
  - DSO Significance
  - Activation Queue
  - Active Data Table
  - Change Log
  - Basic example
  - DSO Creation
  - DSO tables
  - Difference between SDSO/WDSO/DDSO
• Multi provider
  - Operation
• Process chains
  - Structure
  - Use of Multiprovider
  - Introduction
  - 0Infoprovider
  - What is process chain
• Infoset
  -Advantages
• PC creation
  - Structure & Scope
  - Join types
  - General services
  - Use of Infoset
  - Load process & post processing
  - Data administration target
• Virtual provider
  - Other BW process
  - Structure & Scope
  - Types o Process variant types
  - Use of virtual provider
  - Remote process chain
  - Meta Chains
• BI Content
  - ECC
  - BW
• Scheduling types
  - Grouping
  - Job monitoring, Batch monitoring o Installation
  - Event creation & Scheduling
  - Versions
  - Advantages
  - Error analysis
• Open Hub destination (OHD)
  - Types Object collection
  - Example Workbench
• PC Error handling
  - OHD Architecture
• Transport
  - Logs
• Analysis process design(APD)
  - Errors
  - Scenari
  - Data Sources
  - Transformations
  - Targets
  - Example
  - Meta data repository

ECC Content

• ERP
  - Introduction To SAP
  - Enterprise Resource Planning (ERP)
  - ERP System
  - Modules can be found in any ERP system
  - ERP Software’s
• Generic Extraction
  - Introduction to Generic Extraction
  - Types of Generic extractors
  - T codes & Table significance
  - Generic delta
  - Generic ds based on table
  - Generic ds based on view
  - Generic ds based on Infoset
• Logistics
  - Introduction
  - SD business flow
  - Update modes
  - Update Methods
  - T Codes
  - Business Tables
  - Data source naming conventions
  - Standard Data sources examples
  - Setup tables
  - Deletion
  - Filling steps
• MM
  - Introduction
  - Business flow
  - PO business flow
  - T codes
  - Functional tables
  - Standard data sources for inventory
• FI
  - Introduction
  - Basic functional terms
  - T codes
  - Standard data sources
  - Important tables
• COPA
  - Introduction
  - Tables
  - T code
  - Operating concern
  - COPA Characteristics
  - Cost Analysis components
  - COPA Data source creation
• Internal Order (IO) profitability analysis
  - Introduction
  - Tables
  - T code
  - Generic data source
• Vistex
  - Introduction
  - Basic functional terminology
  - Cockpit
  - Setup Details
  - Setup table standard programs
  - Some Standard data sources
• Transport mechanism
  - Object collections
  -TR significance
• SAP delivered objects
• Jobs monitoring

BW/4HANA Content

• HANA DB introduction
• BW prospective
• Introduction to BW on HANA & BW/4HANA
• Basic migration process
• Key features BW & BW/4HANA system
• BW/4HANA Connectivity’s & Symbols
• ODP source
  - ODP Source system introduction
  - ODP Source system
  - Delta Queue Monitoring screen
  - Example data source monitoring
  - ODQ Tables
  - Types of source systems
  - Advantages
• Layered Scalable Architecture (LSA)
  - LSA layers
  - LSA ++ layers
  - Differences between LSA & LSA++
  - Basic data model example
• Field based modeling
  - Fields
  - Info Objects (A,T,H) and Scope
• HANA Optimized info cube
  - Extended star schema
  - Migrate IC to HANA IC
  - Partition & tables
• Transient Provider
  - Introduction
  - Sources
  - Tcode & creation process
  - Analytical index preview & advantages
• Open ODS view
  - Introduction
  - Sources
  - IO objects usage
  - Attributes usage
• Advance data store object (ADSO)
  - Introduction
  - Sources
  - Persistent object is combination
  - Template Structure & functionality
  - Naming convention of Tables and Views
  - Adso templates
  - Difference between ADSO Vs DSO
  - Advantages
• Composite Provider (CP)
  - Introduction
  - Sources
  - Basic scenario & example
  - Preview
  - External Hana views
  - Advantages
• Basic differences for all advanced objects
• External Hana views
• Object collection
• Transport mechanism

Reporting Content

• Creation of query
• Query execution
• Calculated Key figure
• Rows
• Restricted Key figure
• Columns
• Structures
• Single values
• Constant selection with KF
• Free characteristics
• Constant selection with CHAR
• Key
• Currency conversion
• Text
• Unit conversion
• Key & Text display
• NODIM
• Hierarchies
• Formula Collision
• Single values
• Cell definitions
• Include
• Decimal places, scaling factor, sign change
• Exclude
• External access to other systems
• Conditions
• Differences b/w CKF vs RKF
• Exceptions
• Differences b/w Formula vs New section
• Result suppressions
• Differences b/w Conditions vs Exceptions
• Variables
• Differences b/w filters vs Default values
• Selections
• Differences b/w Structure vs cells
• Types of variables
• Report performance guidelines
• Processing types
• Object collection
• Query as info provider
• Transport mechanism
• Ranges
• Selection options
• Selection options Mandatory
• Select options mandatory with default value
• Default value
• New selections single value
• New selections variable value
• Jump query
• Authorization
• Formula