SAP BW On Hana Certification Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  40 Days

About Course

Our SAP BW On Hana training explains the benefits of the new “In-Memory” Solution with SAP BW and equips you to implement and operate SAP BW powered by SAP HANA. It discusses SAP BW components and features that are HANA-specific or optimized. LSA++, a new Layered Scalable Architecture, is introduced. On SAP BW On Hana, you will become acquainted with a HANA-optimized data modeling technique.

SAP BW On Hana Training Course Syllabus

Unit 1: Introduction to SAP BW On Hana

✔ Evolution of HANA Landscape
✔ SAP HANA Basics
✔ SAP BW on HANA

Unit 2: SAP HANA and Business Strategy

✔ 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

Unit 3: HANA-optimized DataStore Object and InfoCube

✔ HANA-Optimized DataStore Object
✔ HANA-Optimized InfoCube
✔ Semantically Partitioned Object

Unit 4: SAP HANA modeling in SAP BW On Hana

✔ Purpose of Information Modeler
✔ Levels of Modeling in SAP HANA
✔ Attribute Views
✔ Analytic Views
✔ Calculation Views
✔ Export & Import

Unit 5: MODELING of SAP BW on HANA with SAP HANA

✔ 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

Unit 6: Consuming HANA Models in BW

✔ Virtual Provider
✔ Transient Provider
✔ Composite Provider
✔ DB Connect
✔ Importing SAP BW models in SAP HANA
✔ Importing HANA optimized info cubes
✔ Importing HANA optimizes DSO

Unit 7: DATA EXTRACTIONS (ETL)

✔ ECC Extractions
✔ Overview of ECC6.0 Extractions.
✔ Generic Extractions
✔ Business Content Extractions
✔ CO-PA Extractions (COST PROFITABLE ANALYSIS)
✔ LO-COCK PIT Extractions (LOGISTICS)

Unit 8: REPORTING

✔ Introduction to BI Enterprise Reporting
✔ Navigating in Reports
✔ First Steps in Query Designer
✔ Key Figures
✔ CHARACTERISTICS
✔ Attributes
✔ Exceptions and Conditions

Unit 09: Transporting Objects (CTO)

✔ 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

Topics Covered MODELING
Unit 1: The Multi-dimensional Model in SAP BW

✔ The SAP BW Star Schema Concept
✔ Data warehousing Workbench (DWB)
✔ Info Objects
✔ Info Cubes

Unit 2: Data Extraction

✔ Loading Master Data (Attributes, Texts, Hierarchies)
✔ Loading Transaction Data

Unit 3: New Data source Concept of BW on HANA

✔ Overview of new Datasource
✔ Migration of 3.x data source to BW 7.4/on HANA data source (LOGISTICS)

Unit 4: Transformation in BW 7.4(ETL)

✔ Transformation

Unit 5: DTP (Data Transfer Process)

✔ Overview of DTPS
✔ Trouble shooting techniques in DTPS
✔ Debugging ABAP routines Using DTPS

Unit 6: Business Content

✔ Business Content (BCT)

Unit 7: Administration of InfoCubes and Aggregates

✔ Managing Basic Cubes
✔ Aggregates

Unit 8: DSO (DATA STORE OBJECTS)

✔ Data Store Objects concept

Unit 9: Virtual Cubes and Multi Providers

✔ Virtual Cubes
✔ Multi Providers
✔ DATA EXTRACTIONS (ETL)
✔ ECC extractions using BW on HANA Data flows

Unit 1: Overview of ECC6.0 Extractions

✔ Types of ECC extractions

Unit 2: Generic Extractions.

✔ Generic Extraction using
✔ Database Table
✔ View
✔ Classical Info sets.
✔ Functional Module.

Unit 3: Business Content Extractions

✔ Overview of Business Content Extractions.
✔ Examples from Financial, Logistics, and HRMS modules.

Unit 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)
Unit 5: LO-COCK PIT Extractions (LOGISTICS)
Unit 7: Delta Management
Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)
Unit 9: Datasource Enhancement
Unit 10: Process Chains in Detail covering all process Types

✔ Real time examples on process Chains (Meta Chains)
✔ REPORTING

Unit 1: Introduction to BI Enterprise Reporting.

✔ The SAP BI Overview

Unit 2: Navigating in Reports
Unit 3: First Steps in Query Designer

✔ Query Designer
✔ Info providers in query Designer

Unit 4: Key Figures

✔ Restricted Key Figures
✔ Calculated Key Figures
✔ Properties of Key Figures

Unit 5: CHARACTERSTICS

✔ Properties and Attributes of Characteristics
✔ Integrating attributes and hierarchies in reports.

Unit 6: Exceptions and Conditions.

✔ Exceptions
✔ Conditions

Unit 7: Bex Analyzer
Unit 8: Transporting Objects (CTO)

✔ NEW ENHANCEMENTS OF SAP BW on HANA

UNIT 1: Hybrid provider
UNIT 2: New monitors in BW Administration cockpit
UNIT 3: Generic delta functionalities for further types of Data Sources
UNIT 4: Hierarchies

✔ 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

UNIT 5: Data Transfer Process (DTP)

✔ 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

UNIT 6: Open Hub Service

✔ 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

UNIT 7: SAP BODS (New ETL Tool of SAP) Integration
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

Weekday

Coming Soon

AM IST

Weekday

5th NOV 2022

8 AM IST

Weekend

Coming Soon

AM IST

Weekend

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.
Preferred

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
For Business

SAP BW On Hana Training FAQ'S

What is the time distribution option in update rule?

This is done to disseminate data in a time-based manner; for instance, if the target contains a calendar day and the source has a week, the data is spit out for each day of the week. You can choose between the default calendar and the factory calendar here.

What are the types of attributes?

Navigational and display-only; display-only qualities are solely for display and cannot be used for analysis; Assume that we have a customer characteristic with the country as a navigational attribute; you may analyze the data using customer and country. Navigational attributes work like ordinary characteristics.

What are the steps to load non-cumulative cube?
  • 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.
Can you partition a cube which has data already?

No, to do this, the cube needs to be empty. Making a clone of cube A and cube B and utilizing an export data source to export data from cube A to cube B are two workarounds; vacant cube A; Make a partition on A, import the data from B again, then remove the B cube.

What is an info source?

a collection of logically connected objects; for instance, the CUSTOMER info source will include information about customers and their associated attributes, such as customer numbers, addresses, and phone numbers.

Get ahead in your career by learning SAP BW On Hana through VISWA Online Trainings

Reviews

Vishnu Gadipudi
Vishnu Gadipudi
2023-08-20
I Enrolled in VISWA Online Trainings for IBM Integration BUS course . Recently I Completed IBM Integration BUS Batch. It was Really Awesome Experience. Best Place To Learn , Experienced Trainer, Gives Us High Level Knowledge....
Navya Biradavolu
Navya Biradavolu
2023-08-20
I was enrolled for looker Bl Tool,it was amazing experience . especially soft skill batch is one of my favourite batch . overall learning process is quite impressive.
Indla sneha
Indla sneha
2023-08-20
I have joined I have joined VISWA Online TRAININGS for Java full stack course and i have completed Advance Java module. I had a good knowledge of Hibernate, spring,spring boot,spring MVC. Tutor has knowledge in depth and is supportive. Srinadh sir solved all our doubts....
bindu hima
bindu hima
2023-08-20
I am recently completed Talend course and trainer is Rajendra very professional and helpful. All the doubts were solved in a precise manner.
Tarunasree Gowra
Tarunasree Gowra
2023-08-20
"I truly enjoyed this course." Chaitanya sir fantastic-very knowledgeable. Sir give us very informative and clear instruction on how to achieve the goal. Thank you!
Tejaswini Kommu
Tejaswini Kommu
2023-08-20
Overall Linux Admin sessions batch was very good. Mr. RAM Krishna teaching was very helpful to remind our basic concepts in linux & networking.
Gopanaboina Mounika
Gopanaboina Mounika
2023-08-20
It was great learning with such a great and experienced staff. Praveen Sir (Oracle EPM Cloud - FCCS) was very helpful and operations team also very helpful in solving any minor problems students go through process.
Jyothi Gutlapalli
Jyothi Gutlapalli
2023-08-20
I like to share my experience which provide lots of courses and one of those I recently completed my Salesforce BA Course and I like to tell you it was a great experience and my knowledge and confidence is really boosted after completing this course.
Harshibandi
Harshibandi
2023-08-20
Good experience and great learning platform for Hyperion Essbase and Planning. The faculty is also well trained and soft spoken.
Chaitu Viswa
Chaitu Viswa
2023-08-20
It was very good session for QlikView. I would like to thank to teacher Mr.Chandu for providing guidance for the required modules. Thanks VISWA Team for giving apportunity to leran new skills.

Quick Links