SAP BW On Hana Certification Training
Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.
Learners : 1080
Duration : 30 Days
About Course
Our SAP BW On Hana course enables you to implement and maintain SAP BW powered by SAP HANA and outlines the advantages of the new “In-Memory” Solution with SAP BW. It explains HANA-specific or optimized elements and aspects of SAP BW. By introducing a new Layered Scalable Architecture (LSA++).you will familiarize yourself with a HANA optimized data modeling approach on SAP BW On Hana.
SAP BW On Hana Training Course Syllabus
✔ Evolution of HANA Landscape
✔ SAP HANA Basics
✔ SAP BW on HANA
✔ Identifying Transformational Opportunities
✔ Understanding Your Needs, Enterprise Needs, and Data Needs
✔ Working with Existing Solutions: SAP HANA versus SAP NetWeaver BWA
✔ Does SAP HANA Replace BW on HANA?
✔ Pros and Cons of BW on HANA
✔ Pros and Cons of SAP HANA
✔ HANA-Optimized DataStore Object
✔ HANA-Optimized InfoCube
✔ Semantically Partitioned Object
✔ Purpose of Information Modeler
✔ Levels of Modeling in SAP HANA
✔ Attribute Views
✔ Analytic Views
✔ Calculation Views
✔ Export & Import
✔ Models in SAP BW on HANA
✔ Data Extraction and Data Flow within SAP BW on HANA
✔ Transformation
✔ DTP (Data Transfer Process)
✔ Administration of InfoCubes and Aggregates
✔ DSO (DATA STORE OBJECTS)
✔ Virtual Cubes and Multi Providers
✔ Virtual Provider
✔ Transient Provider
✔ Composite Provider
✔ DB Connect
✔ Importing SAP BW models in SAP HANA
✔ Importing HANA optimized info cubes
✔ Importing HANA optimizes DSO
✔ ECC Extractions
✔ Overview of ECC6.0 Extractions.
✔ Generic Extractions
✔ Business Content Extractions
✔ CO-PA Extractions (COST PROFITABLE ANALYSIS)
✔ LO-COCK PIT Extractions (LOGISTICS)
✔ Introduction to BI Enterprise Reporting
✔ Navigating in Reports
✔ First Steps in Query Designer
✔ Key Figures
✔ CHARACTERISTICS
✔ Attributes
✔ Exceptions and Conditions
✔ Hybrid provider
✔ Generic delta functionalities for further types of Data Sources
✔ Hierarchies
✔ Data Transfer Process (DTP)
✔ Open Hub Service
✔ Transformation
✔ SAP BODS (New ETL Tool of SAP) Integration
✔ The SAP BW Star Schema Concept
✔ Data warehousing Workbench (DWB)
✔ Info Objects
✔ Info Cubes
✔ Loading Master Data (Attributes, Texts, Hierarchies)
✔ Loading Transaction Data
✔ Overview of new Datasource
✔ Migration of 3.x data source to BW 7.4/on HANA data source (LOGISTICS)
✔ Transformation
✔ Overview of DTPS
✔ Trouble shooting techniques in DTPS
✔ Debugging ABAP routines Using DTPS
✔ Business Content (BCT)
✔ Managing Basic Cubes
✔ Aggregates
✔ Data Store Objects concept
✔ Virtual Cubes
✔ Multi Providers
✔ DATA EXTRACTIONS (ETL)
✔ ECC extractions using BW on HANA Data flows
✔ Types of ECC extractions
✔ Generic Extraction using
✔ Database Table
✔ View
✔ Classical Info sets.
✔ Functional Module.
✔ Overview of Business Content Extractions.
✔ Examples from Financial, Logistics, and HRMS modules.
✔ Real time examples on process Chains (Meta Chains)
✔ REPORTING
✔ The SAP BI Overview
✔ Query Designer
✔ Info providers in query Designer
✔ Restricted Key Figures
✔ Calculated Key Figures
✔ Properties of Key Figures
✔ Properties and Attributes of Characteristics
✔ Integrating attributes and hierarchies in reports.
✔ Exceptions
✔ Conditions
✔ NEW ENHANCEMENTS OF SAP BW on HANA
✔ Integration of hierarchies into process flow (DTP, Transformation)
✔ Remote hierarchies for direct access to hierarchies in the source system
✔ Loading hierarchies from flat file using the new Data Source and Transformation technology
✔ Data Transfer Process supports data extraction from Multi Providers
✔ Option to only load the last request from a given source (available for full load DTPs)
✔ Data Transfer Process supports referential integrity checks tor navigational attributes of the target
✔ Enhanced load performance by the possibility to Re- package small data packages within a request to bigger packages
✔ SAP Net Weaver BW data can be exported in XML format
✔ Possibility to change the format and length of BW data for export even into a non-SAP specific format
✔ Hierarchy extraction supported by Open Hub
Live Instructor Based Training With Software |
Lifetime access and 24×7 support |
Certification Oriented content |
Hands-On complete Real-time training |
Get a certificate on course completion |
Flexible Schedules |
Live Recorded Videos Access |
Study Material Provided |
SAP BW On Hana Training - Upcoming Batches
7th NOV 2022
8 AM IST
Coming Soon
AM IST
5th NOV 2022
8 AM IST
Coming Soon
AM IST
Don't find suitable time ?
CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE
Live Virtual Training
-
Schedule your sessions at your comfortable timings.
-
Instructor-led training, Real-time projects
-
Certification Guidance.
Self-Paced Learning
-
Complete set of live-online training sessions recorded videos.
-
Learn technology at your own pace.
-
Get access for lifetime.
Corporate Training
-
Learn As A Full Day Schedule With Discussions, Exercises,
-
Practical Use Cases
-
Design Your Own Syllabus Based
SAP BW On Hana Training FAQ'S
This is to distribute data according to time; for example, if the source contains calendar week and the target contains calendar day, the data is spit for each calendar day. Here you can select either the normal calendar or the factory calendar.
Display only and navigational; display only attributes are only for display and no analysis can be done; navigational attributes behave like regular characteristics; for example assume that we have a customer characteristics with country as a navigational attribute; you can analyze the data using customer and country.
- Initialize opening balance in R/3 (S278)
- Activate extract structure MCO3BFO for data source 2LIS_03_BF
- Set up historical material documents in R/3
- Load opening balance using data source 2LIS_40_S278
- Load historical movements and compress without marker update.
- Set up V3 update
- Load deltas using 2LIS_03_BF.
No; the cube must be empty to do this; one workaround is to make a copy of cube A to cube B; export data from A to B using an export data source; empty cube A; create a partition on A; re-import data from B; delete cube B.
Group of logically related objects; for example the CUSTOMER info source will contain data related to customers and attributes like customer number, address, phone no, etc.
Get ahead in your career by learning SAP BW On Hana through VISWA Online Trainings