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