SAP
HANA Training Online | SAP HANA Training Certification:
SAP HANA online Training providing you by real time experts at Tectist. We offer SAP HANA online training and all SAP Modules online training.
SAP HANA Online Training Course Content
Introduction to SAP HANA
- SAP In-Memory Strategy
- HANA compare to BWA
In-Memory Computing, Big Data and SAP HANA
- Introduction to In-Memory Computing and Big Data
- In-Memory Computing and Analytics
- Big Data Introduction
- Introduction to SAP HANA
- SAP HANA as in In-Memory Computing Solution
- SAP HANA as an Enabler of Big Data Solutions
- SAP HANA Capabilities
- SAP HANA Database Concepts…..
- Impact of Modern Hardware on Database System Architecture.
Architecture
- Hana Engine Overview
- IMCE surroundings
- Different HANA Engine Types
- Row Store
- Column Store
- Persistency Layer
- Business Impact of new architecture
- Columnar and Row-Based Data Storage
- Advantages of Columnar Tables
Data Modeling with SAP HANA Studio
- SAP HANA Studio Overview and Terminology
- Getting Started with SAP HANA Information Modeler
- Adding a System
- Opening Perspectives
- Using Quick Launch
- Creating a Package
- Example Scenario
- Building Attribute Views
- Creating an Attribute View
- Defining Table Joins 4
- Defining Output
- Checking, Saving, and Activating Views
- Creating the Time Attribute View
- Building Analytic Views
- Creating an Analytic View
- Copying an Analytic View
- Building Calculation Views Using the Graphical Method
- Implement information models in SAP HANA
Advanced Concepts in SAP HANA Studio
- Derived Attribute Views
- Calculated Attributes
- Restricted and Calculated Measures
- Filter and Variable Operations
- Filters
- Variables and Input Parameters
- Currency Conversion
- Creating a Leveled Hierarchy
- Creating a Parent-Child Hierarchy
- Processing Content Objects
- Previewing Data of Content Objects
- Validating Models
- Comparing Versions of Content Objects
- Viewing Version History of Content Objects
- Switching Ownership of Inactive Objects
- Generating Object Documentation
- Enabling Multilanguage Support for Objects
- Checking Model References
- Viewing the Job Log
- Personalizing Studio
- Versioning
- Checking Model References
- Customizing Perspectives
HANA SQL
- Introduction to SQL script and script based calculation views 5
- Using SQL & Using SQLScript
- Using SAP HANA Studio to Execute SQL and SQLScript Statements
- Table Type Definition
- CREATE TYPE
- DROP TYPE
- INSERT, UPDATE, DELETE statements
- Data definition and access control
- Data Types
- CREATE, ALTER, DROP
- Renaming Columns
- Functions & Expressions
- Procedures introduction
- Writing procedures
- Procedure Calls
Data Provisioning
- Choosing a Data Provisioning Method
- Strategic Considerations
- Technical Considerations
Option 1: Trigger-Based Replication: SAP Landscape Transformation
- How SLT Works
- SLT Configuration
- SLT Administration (Start, Replicate, Stop, Suspend,Resume)
- Extended Features
Option 2: ETL-Based Replication: SAP Data Services
- Preparing SAP HANA to Receive Data from SAP Data Services
- Loading Data
Option 3:Log-Based Replication: Sybase Replication Server and Load Controller
Option 4: Direct Extractor Connection
- DXC Technology
- Important Considerations for the Use of DXC 6
Reporting
- SAP HANA and the SAP BusinessObjects BI Platform
- Overview of the SAP Business Objects Tools
- SAP Business Objects Dashboards (Xcelsius) .
- SAP Business Objects Web Intelligence
- SAP Business Objects Explorer
- SAP Business Objects Analysis
- SAP Business Objects Design Studio
- SAP Crystal Reports
- Connecting SAP Business Objects BI Tools to SAP HANA
- Universes with Open and Java Database Connections (ODBC/JDBC)
- IDT Access to Attributes, Calculations, and Analytical Views
- Connecting to Excel with Open Database Objects (ODO) and MDX
- BICS Connections
- Connectivity Summary
User Management & Administrator
- Security
- Creating Users
- Creating Roles
- Privileges
- User Administration 7
Hot Topics
- BW 7.3 powered by HANA Overview
- Business Suite on HANA Overview
- Rapid Deploy Solutions Overview
- HANA Innovations
- Information Composer
- Exercises
CASE STUDY – COPA Scenario
- Steps:
- Provisioning the relevant tables
- Creating attribute view, analytic view & calculation views for COPA Model.
Resource: www.tectist.com
