Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in SAP BW on Hana
| Course Duration | 30 hrs | ||
|---|---|---|---|
| Live Projects | 2 | ||
| Next Batch | 25 Jan, 2020 30 Jan, 2020 02 Feb, 2020 |
||
Module One: Enterprise Structure Introduction to ERP
SAP Data Warehouse Overview of BW, BI Data Base
Overview of BW Architecture
Landscape Basic Modeling
Create a valid Schema Multi-Dimensional Model
The Star, Schema (Classical Approach) Multi-Dimensional Star
Schema in BW (Extended star Schema), The OLAP Concept
Differences between OLAP and OLTP Business Modeling
Info Area, Info Object Catalogs and Info Objects
PSA
Application Component
Info Source, Data Source
Transfer Rules, Update Rules
Transfer Structure, Communication Structure
Info Package
Transformation, Data Transfer Process
Loading Transactional Data into BW info Cube, Loading MD with TD into BW System, BW and BI Comparisons Master
Data loading-new (BI) ETL process
Info cube & Types
Standard Info cube and Loading with new ETL Process
Generate Report with BI master and Transaction Data
Manual Uploading of MD like Attributes
Text, Hierarchy
Different Types of Attributes Transformations
Start Routine
End Routine
Expert Routine
Standard DTP
Error DTP
Direct Access DTP
Real time DTP
Standard DSO
Write optimized DSO
Direct update DSO
APD (Analysis Process & Design)
Update Methods
Full updates
Initialization
Delta Updates
Multi Providers
Info set
Virtual Providers
Re-Modeling
Re-Partitioning
Open-Hub Destination
Data Marts
Aggregates
Roll-up
Compression
Reconstruction
Process Chains
Process Types
Scheduling
Monitor (Header, Status, Details)
BEX Query designer
BEX Analyzer
BEX WAD
BEX Report Designer
Visual Composer
Functional Overview of BEX Query
Designer Reusable Query Elements
Query Controls with Variables
Calculated Key Figures
Restricted Key Figures
Formulae
Structures
Variable Definition in Detail
Characteristic values variables
Text Variables
Formula Variables
Hierarchy Variable
Conditions
Exceptions
Reporting Drilldown
Drilldown to DSO from Info Cube (RRI)
Copying Queries from Cubes
Bex Analyzer, Bex WAD, Bex Report Designer
Visual Composer Migration Objects from BW 3.x to BI 7.0
Transportation Extraction
Generic Data Extraction using MD/TD Tables
COPA Extraction
Business Content Extractions using MD/TD
LO-COCKPIT Data Extraction
Delta types for Generic Extraction
LO Extraction
ASAP methodology
Have questions? We’ve got the answers. Get the details on how you can grow in this course.
Have More Questions. Reach our Support Team
Contact usSee if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate
Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in SAP BW on Hana
By providing us with your details, We wont spam your inbox.