SAP BW ON HANA
Training
Online
*Indicative price
Original amount in INR:
₹ 20,565
Description
-
Type
Training
-
Level
Intermediate
-
Methodology
Online
-
Duration
1 Month
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
SAP Business Warehouse (BW) powered by SAP HANA helps you speed up data analysis by consuming data via a Data Warehouse (DW) for analytical reporting and data analysis. You can achieve key opportunities like real-time data integration and data modeling, and hence real-time BI reporting on large amount of data in the database.
SAP Business Warehouse continues to act like a powerful data warehouse tool to consolidate master data and provide flexible reporting options. With SAP HANA underneath BW system as a database, you can use a combination of DW capabilities with fast in-memory database to achieve performance improvements and exceptional modeling capabilities.
HANA in-memory database is much faster as compared to other common databases like Oracle, SQL Server, and hence DW performs much faster when powered by HANA as database underneath it. It combines the power of both the tools - BW Modeling and HANA in-memory computing engine to process huge amounts of data.
BW on HANA supports various exceptional databases and reporting capabilities that are not possible using other databases - like transformations and DSOs are moved to HANA database to provide much faster processing of data, data load performance, query processing and optimization, exceptional HANA modeling capabilities, etc.
About this course
Consultants and customer project team members that are implementing and maintain SAP BW powered by SAP HANA.
Before you start proceeding with this tutorial, we assume that you are well-versed with basic BW and HANA concepts, like DataStore Objects (DSO), Data Transformations, InfoCubes, Query optimization, HANA Modeling and HANA DB features using HANA Studio. If you are not aware of these concepts, then we recommend that you first go through our tutorials on BW and HANA.
Reviews
Subjects
- SAP
- Database
- SQL
- Database training
- Data analysis
- BI
- BW
- Texts
- Conventions
- SAP and BI
Course programme
Introduction (10 Hours)
- General Introduction.
- SAP introduction.
- Data warehousing/ BW/ BI Introduction
- Master data; Attributes, Texts, and Hierarchies.
- Standard Naming conventions in SAP and BI
- Info Objects: Definitions
- Types: Characteristics, Key Figures, Time, and Unit.
- InfoCube: Definitions.
- Types: Standards, real time, remote.
- Design of InfoCube: Star Schema concepts. Precautions.
- Data Store objects (DSO):
- Types: Standards, Real time.
- Info Sets
- MultiProviders: Scenarios to create Multiproviders.
- InfoCube VS DSO
- Hybrid Provider
- Semantic Provider
- For SAP source systems: Creating Generic datasource and maintaining SAP delivered datasource.
Creating datasource for File Source Systems
Defining transformations
- Transformations and different scenarios.
- Creating data transfer processes
- Creating process chains
- Checking process chain runs
- Monitor for extraction processes and data transfer processes
- Creating the first aggregate for an InfoCube
- Using compression, partitioning, indexing on cube.
- Transports:
- Real business scenarios on different system environments, Moving objects from one system to another.
- BEx Query Designer
- Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
- Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures
- Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
- Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures Activities
- BEx Analyzer
- OLAP OLTP: The OLAP Concept and differences between OLAP and OLTP
- OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface
- Metadata Repository: Searching for Metadata
Course Overview
- This course enables you to implement and maintain SAP BW powered by SAP HANA and outlines advantages of the new "In-Memory" Solution with SAP BW. It explains HANA
- specific or optimized elements and aspects of SAP BW. With introducing a new Layered
- Scalable Architecture (LSA++). You will familiarize with a HANA optimized data modeling approach on SAP BW.
- SAP BW Overview
- The source of data for BW system
- Data flow in BI system
- SAP HANA Overview
- Exploring In-Memory analytics
- BW Powered by HANA
- Engines in SAP HANA
- LSA Layer An BW EDW with LSA is perceived as highly valuable but
- LSA++ Layer
SAP HANA Modeling in detail:-
- Creation of Schemas, Catalogs, tables using SQL Script and GUI.
- Loading of data via SQL script and Flat Files
- Creation of Packages
- Creation of Attribute Views, Analytical View & calculation Views.
- Assigning full privileges to Users.
- Creation of BW projects.
- InfoObject modeling (more than 60 characters)
- HANA optimised DSO
- HANA optimised Infocube
- Composite provider
- Open ODS
- Advanced DSO
- Transient provider
- Virtual provider
HANA as source system via DB Connect
SLT as an source system
BW Workspace
SAP BW ON HANA
*Indicative price
Original amount in INR:
₹ 20,565