:
: contact@londontraininginstitute.co.uk
: (+44) 0203 617 1437 | Contact Us | Corporate Training | Blog

SAP BW on HANA Training

BW362 SAP BW on SAP HANA

SAP (System Applications and Products) BW (Business Warehouse) on HANA (High-Performance Analytical Appliance) is a complete solution for the data warehouse of any business. In short, it is known as SAP BW/4 HANA, which is well known for the on-premise data warehouse layer of SAP’s Business Technology Infrastructure.

 

You will learn how to consolidate data throughout the business to ensure consistent progress and explore almost every required feature of HANA database technologies, including utilizing BW for business process modelling. You will also be able to deal with Analytical reporting and Data modelling. SAP BW/ 4 HANA supports the processes and accelerates innovation from a particular source to generate real-time business insight. You will be able to capitalize your data with the help of third-party solutions using SAP Applications.

 

Validate your knowledge with SAP Certification. Become a recognised SAP-certified solution expert. 

Benefits of SAP Global Certification:

  • Gain a highly recognised, on-demand accreditation of excellence
  • Differentiate yourself in a crowded market
  • Execute tasks with confidence and skills
  • Attain higher wages and billable rates with a highly valued credential

 

Starting Date

Timing

Days

Duration

Booking

26/02/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

02/03/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

04/03/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

11/03/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

16/03/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

18/03/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

25/03/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

30/03/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

01/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

08/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

13/04/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

15/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

20/04/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

22/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

27/04/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

29/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

04/05/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

06/05/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

11/05/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

13/05/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

18/05/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

20/05/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

 

SAP System overview

 

  • What is ERP? Different business modules of ERP.
  • Two-dimensional tables.
  • Master data and Transaction data.
  • BW Overview
  • Star Schema Concepts
  • Multidimensional modeling.
  • OLTP Vs OLAP.
  • Data Warehousing in BW

 

Datawarehousing workbench

 

  • Creation of Info area, Info object catalogs, Info objects, and attributes.
  • Maintain master data.
  • Creation of source system (Flat file).
  • Creation of data sources, transformations, DTPs, and info packages (basic).
  • Loading master data from a flat-file into an info object.
  • Creation of basic cube and loading transaction data into info cube.
  • Monitoring data after the load triggered.
  • Concepts in basic modeling 
  • Creation of a simple DSO and loading transaction data into DSO.
  • Datamart concepts – Loading data from DSO to cube.
  • Types of attributes – Display, Navigational, compounding, and Transitive.
  • Attribute change run to activate master data.
  • Transformation rules – writing start routine, end routines (ABAP), and transformation rule groups.
  • Delta mechanism in BW.
  • DTP concepts in detail – Types of DTPs, delta add-ins in DTP.
  • Understanding the aggregation behavior of key figures in a basic report.
  • Data Extraction from Source Systems

 

Data Extraction overview

 

  • SAP R3 business process overview of Sales, purchasing and MM.
  • The extraction process
  • Types of extractors
  • Logistics data extraction
  • What is meant by logistics? Business areas of LO cockpit.
  • Configuring of datasource, setup table filling and delta queue management.
  • Different types of delta update methods – Queued, V3 serialized and direct.
  • Process of Inventory data extraction with marker updates.
  • Generic data extraction
  • Creation of Data sources for master data and transaction data.
  • Creation of master data based on table, view, infosets and Function module.
  • Concepts of generic delta.
  • Data sources for classification data (special features).
  • Controlling and FI data extraction

 

Installing and activating business content Datasources

 

  • Delta procedures
  • Safety interval features
  • Enhancing a data source
  • Enhancing data sources for master and transaction data.
  • Basic overview ABAP coding to write the code for enhancement.
  • Extraction from Oracle Database
  • Setting up ODBC connection to oracle DB
  • TOAD or SQL Developer tool overview
  • Reporting

 

Introduction to reporting tools

 

  • BEx Query designer,
  • BEx Analyzer,
  • BO Web intelligence
  • BO Dashboard designer.
  • Getting started with Query designer
  • Rows, columns, free Chars, default values and Filters.
  • Properties of Query, char and key figure in BEx.
  • What is drill down and navigational analysis?
  • Data restrictions of char at different places in query designer.
  • Creation and usage of the following objects.
  • Calculate key figures, restricted key figures, New Selection, New Formula

 

Conditions, Exceptions, Structures

 

  • Variables – different types of variables with processing types and their usage in real time
  • BEx Analyzer
  • Creating templates with different formatting items.
  • Integrating templates in the workbooks.
  • Creating Query views.
  • Broadcast the reports using Information broadcasting feature.
  • Complex Report requirements
  • How to get the Count of document using formula with replacement path option.
  • Designing Report to report interface for detailed level analysis of queries.
  • How to work with Exception aggregation effectively.
  • Writing the Customer exit variable code in CMOD to calculate YTD, YTM and importance of i_step1 and i_step2.
  • Creating input-ready query on aggregation levels and enter plan data manually.
  • Business Objects Web Intelligence
  • BI launchpad
  • Creating an BEx universe
  • Creating a Webi document and query
  • Navigations and reporting features.
  • Dashboard Designer
  • Creating a dashboard on BEx query
  • Creating a dashboard on flat file data
  • Dashboard on BO Webi data

 

Administration and Performance

 

  • Creation of Hierarchies and loading hierarchy from a flat file.
  • Types of DSO and Types of Info cubes.
  • Multi-provider and Infoset.
  • Business Content Installation.
  • Transport Connection – Transport request sequence and resolving errors.
  • Query Performance techniques.
  • Compression, Partition, Index creation, Aggregates – Rollup
  • Load performance techniques.
  • Deleting index and Usage of background process effectively.
  • Open Hub service – Retracting data from BW into the File system and other DB external systems.
  • Currency Conversion and Quantity Conversion in Real-time

Obtaining any SAP certification is a boost for your career success and a valuable credential in any competitive career market.

If you are,

  • a professional working with SAP products who wants to improve your SAP skills,
  • a company who wants to use SAP products to streamline your business processes,
  • a novice looking to add a highly recognised credential to your professional skills,

SAP training with SAP Training London is for you!

Our instructors are highly skilled with industry experience of  many  years, working in a best and renowned organization. Our Trainers follow an approach to engage students during instruction and thus the training methods are modified as per the trainees’ needs which may include direct 1-1 discussions, group discussions, Q&A rounds etc.  Also, you get many more advantages along with a highly professional approach.

  • Flexible course timing to suit you
  • Offer highly competitive course prices
  • You will get Certificate of completion at the end of course
  • We are centrally located and have good access from all corners of London
  • We offer  Hands on training with lab access
  • Small group training approach is followed, up to 5

Starting Date

Timing

Days

Duration

Booking

26/02/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

02/03/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

04/03/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

11/03/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

16/03/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

18/03/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

25/03/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

30/03/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

01/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

08/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

13/04/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

15/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

20/04/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

22/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

27/04/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

29/04/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

04/05/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

06/05/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

11/05/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

13/05/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now

18/05/2024

10:00 – 16:00

Sat Only

5 Weeks

Book Now

20/05/2024

09:00 – 17:00

Mon - Fri

5 Days

Book Now
Get a reply within a day

Any questions ?





    Input this code: captcha

    Related Courses

    SAP Training London is rated 5 stars on Facebook based on 3 reviews