Call Us at: +1616-469-0394 | Email: info@hexissoft.com

Follow Us on: facebook_icon twitter-icon linkdein_icon

COURSES

QUICK ENQUIRY











aboutus_banner

SAP BI/BW Online Training

SAP BI/BW

Introduction

Overview of SAP R/3
• Necessity of SAP BW & Version of BW
• OLAP & OLTP
• Data Ware Housing Concepts
• Landscape of SAP BW
• Integration of BW system with different systems
• ERM, MDM, Star Schema & Extended Star Schema.
 
Objects in SAP BW
• Info Area, Info Object Catalogs
• Characteristics
• Key Figures-Cumulative & Non Cumulative
• PSA- Transfer Structure/Data sources
• Transfer Rules
• Info Source/Communication Structure
• ODS- Info Cubes
• Types of Info Cubes- Update Rules
Data Loading Using Flat Files
• Master Data – Attributes, Texts, Hierarchies
• Transaction data-Delta data loading
Data Filtration Techniques
• Transfer Rules level
• Update Rules level
• Start Routines
PSA-Maintenance scheduling the data
• Data Packet by Packet
• Complete scheduling
• Scheduling in background
• Transfer Rules & Update Rules
• PSA-Processing Types
• Monitoring & scheduling data loading
• Scheduling the jobs on periodic values
• Cancellation & Deleting the back ground jobs
SAP-BI 7
Bi Concepts & Overview
Modeling: Data warehousing workbench
• Components of data warehousing workbench
• InfoObjects, data source,
• Types of DSO’s , Data Source Repository
• Migration of 3.X data sources & Recovery of 3.X Data sources
• Difference between ODS & DSO
• Data Loading – Master Data & Transactional Data.
• Concepts of Transformation & Its Types
• Controlling the data-flow with Infopackages (IP)& Data Transfer Process (DTP)
• Data Loading into DSO & InfoCubes
• Standard –Direct DSO –Write Optimized DSO.
Types of Info Cubes, Info Sets, MultiProvider
• Open Hub & Performance Issue
• Deleting data from data target
• Query performance & Load Performances
Business Content
• Important of business Content
• Business Content Installation & Activation
• Business Content Data Source, DSO’s, Cubes, Reports, etc…
Meta Data Repository
• Important of Metadata Repository
Extraction
• Flat file & LO Extraction
• Generic Extraction & Generic Delta
• FI-SL, Co-PA, DB Connect
• Business Content Extraction
• Data Enhancements- Tables, View, Query
Process Chain
• Types of Process Chains
• Process Groups & Meta Chain, etc…
Transport Mechanism
• Review of system Landscape
• Collecting Objects
• Creating Transports
• Releasing Transport
• Importing Transport
• Monitoring Transport
Authorization Concepts
• Authorization
• Creating & Assigning Roles
BI 7.0 Reporting
BEx Query Designer
• Introduction of BEx Query
• Filters, Columns & Rows
• Characteristic Restrictions & Free Characteristics
• Formulas & Calculated Key Figures
• Restricted Keyfigures & Variables with Texts.
Web Application Designer
• Creating Web Templates
• Web Item & properties
• Drop-down Functions
• Condition & Integration
Business Explorer Analyzer
• Introduction to BEx Analyzer
• Filtering Option
• Properties Available in Analyzer
Report Designer
• Creating Reports
• Formatting columns & Rows
• Changing font styles with background color
• Inserting Rows & columns
Integrated Planning
• Introduction & Planning Application- On web, MS Excel
Types of Projects
• Real Time Implementation Projects
• Up-Gradation project
• Enhancements to the existing Implementation project
• Support project
Advanced Topics in BI 7.0
• Analysis process Designer
• Modeling/Repartitioning
• Data Mart
• Open Hub Destination
• Infoset
• Multiprovider

Back to Top…