SAP HANA Training | SAP Certifications Course SAP HANA Training | SAP Certifications Course

SAP - HANA

SAP HANA Training

SAP Hana is best suited for performing real-time analytics and developing and deploying real time applications. Long before we started accumulating large quantities of data for analytical purposes, engineers knew that moving data to the CPU, with effective speed, will be a challenge. Even though Hard Disk Drives are pretty fast but still not fast enough. Now with SAP HANA a report that typically took almost 24 hours to generate with traditional hard disk drives takes less than a minute.

Innovative Technology Solutions offers HANA Training in 9 different locations in India – Bangalore,Chennai,Delhi,Gurgaon, Hyderabad,Kolkata,Mumbai, Noida & Pune.

We only provide trainers on SAP, we don't have software. For Certification in SAP people need to attend official delivery through SAP.

Prerequisites

Candidates must have
  • A basic idea of information technology domain
  • Basic of database
  • Basis of business process and analysis
  • Fair idea of Business Warehouse (BW) and BI reporting tools

HANA Course Outline

  1. INTRODUCTION TO HANA
    • What is In Memory Technique?
    • Benefits of SAP HANA
    • Row store and Column store discussion
    • Partitioning and Compression discussion
  2. HANA ARCHITECTURE
    • Discussion about Index Server, Name Server, PreProcessor Server, XS Engine, Compilation Server, Demon Server, Statistics Server
    • Transaction Manager, Session/ Connection Manager, Metadata Manager, Authorization Manager
    • OLAP Engine, Calculation Engine, Join Engine, Row Store Engine, SQL Optimizer
    • Discussion Data Volume and Log Volume
    • Configuration : Change time interval for Save Point
    • Data backup and recovery
  3. DISCUSSION ON DIFFERENT REPORTING TOOLS USED
    • Analysis Edition for MS Office
    • Excel
    • Web Intelligence, Dashboard Designer and Crystal Reports
    • Lumera
  4. HANA STUDIO
    • Modeler Perspective
    • Administration Perspective
    • Modifying hosts file
    • Adding HANA system in Modeling Panel
    • Discussion about Catalog
    • Discussion about User Defined Schema, System Defined Schema and SLT Derived Schema
    • Discussion about system schema _SYS_BIC , _SYS_BI,_SYS_REPO, _SYS_STATISTICS , _SYS_XS- ENGINE
  5. HANA SQL
    • Comments
    • Creating and Dropping SCHEMA
    • SQL - Data Types
    • Creating Row Table and Column Table
    • Changing Row table to Column Table
    • Altering , Updating, Inserting , Dropping Table
  6. ADVANCED MODELING
    • Creating Attribute View
    • Derived Attribute Views
    • Shared Attribute Views
    • Calculated Attributes
    • Time Characteristics Based Attribute Views
    • Stand Alone Text Tables
    • Using Base Table Aliases
    • Hidden Attributes
    • Types of Joins Inner Join, Left Outer Join, Right Outer Join, Text and Referential Join
  7. HIERARCHIES
    • Creating Leveled Hierarchies
    • Creating Parent Child HierarchieS
  8. RESTRICTED AND CALCULATED MEASURES
    • Calculation before aggregation
    • Filters
    • Variables
    • Input Parameters
    • Difference between Filters and Varaibles
    • Types of Variables and Input Parameters
  9. ANALYTICAL VIEW
    • Calcualtion View
    • Creating Calculation View Graphically
    • Simple Calculation Views
    • Projection , Aggregation nodes discussion
    • Projection vs Aggregation
    • Join, Union, Rank nodes
    • Creating SQL Script Calculation View
    • Creating Index . BTREE , CPBTREE
    • Dropping Index
    • Creating TABLE TYPES
    • Creating Stored Procedures
    • Creating Stored Procedures Graphically
    • Calling Procedure
  10. PARTITIONING
    • Creating HASH, ROUNDROBIN and RANGE Partitioning
    • Add Partitions, Drop Partitions and Merge Partitions
    • Creating Mixed Partitions
    • Full Text Search
    • Fulltext Search capabilities of SAP HANA
    • Fulltext Search benefits
    • Text Searching Engines
    • Fuzzy Search Introduction
    • Fulltext Search Processes
    • Data Types and Fulltext Indexes
    • Fulltext Search SQL Syntax
    • Currency Conversion
    • Currency Conversion in Analytic View
    • Currency Conversion in Calculation View
    • List of TCUR to be replicated and populated from ECC
  11. INTRODUCTION TO BW 7.4
    • How to access HANA Tables and Views in ABAP Programs
    • How to create HANA Procedures using ABDP procedures in SAP ABAP
  12. CE FUNCTIONS
    • ITS ADVANTAGES
    • CE_COLUMN_TABLE , CE_JOIN_VIEW, CE_JOIN_VIEW
    • CE_OLAP_VIEW, CE_CALC_VIEW , CE_JOIN , CE_LEFT_OUTER_JOIN
    • CE_RIGHT_OUTER_JOIN , CE_PROJECTION, CE_AGGREGATION, CE_UNION_ALL
    • CONTROL STATEMENTS
    • IF ELSEIFELSE
    • WHILEENDWHILE
    • For ENDFOR
    • Dynamic SQL
  13. SECURITY AND AUTHORISATIONS
    • User Management & Security
    • User and Role Concept
    • Assign Privilege to User or Role
    • Types of Privileges
    • SQL Privilege
    • Package Privilege
    • System Privilege
    • Analytic Privilege
    • Object Privileges
    • Pre-delivered Roles
  14. DATA PROVISIONING USING FLAT FILE UPLOAD
    • Loading flat file data into SAP HANA
    • Table Definition and Data Mapping
    • Data loading using Web Methods
    • Data Provisioning using SAP Data Services
    • Introduction to SAP Data Sevices
    • Loading data into HANA using DS
    • Standard vs ABAP Dataflows
    • Template Tables
  15. TRANSPORTATION
    • HANA System Landscape
    • Creating Delivery Unit
    • Assigning Packages to DU
    • Exporting and Importing
  16. SAP LT REPLICATION SERVE - SLT
    • Overview - Trigger-Based Approach
    • Architecture for Non-SAP Source Replication
    • Set-up of LT Replication Server
    • Creating a New Configuration for SAP SourceS
    • Data Replication
    • Load, Replicate, Suspend, Stop, Resume
    • Administration and Monitoring at a Glance
    • SLT based transformation concepts
    • Advanced Replication Settings
    • Define Table Settings
    • IUUC_REPL_TABSTG
    • IUUC_ASS_RUL_MAP
    • IUUC_SPC_PROCOPT
    • IUUC_PERF_OPTION
    • Extension of (target) table structure and Partitioning
    • Enhanced Table Settings – Partition
    • Types of Transformation Rules
    • Selective data replication / filtering
  17. SAP HANA REPORTING TOOLS
    • Reporting using Excel
    • Reporting using Advanced Analysis for MS Office
    • Introduction to Reporting tools of Business Objects (Webi, Crystal Reports, Dashboard Designer, Explorer, Lumera)
    • Installing HANA Client
    • Creating HANA ODBC Connection
    • Creating Universe using Information Design Tool
    • Creating reports using Web Intelligence
    • Analyzing data using Lumera
For More info kindly contact us.