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