Training-SAP-HANA

• HANA Introduction
  • Database fundamental
  • Introduction to SAP HANA – history
  • In memory strategy
  • In-Memory Computing Studio
  • Administration view
  • Navigator View
  • System Monitor
  • Information Modeler
  • Row Store vs Column Store
• Deployment Strategies
  • On-Premise
  • On-Cloud
  • Side-Car
• Data Provisioning
  • Method 1–Data Provisioning using FLAT FILES
  • Method 2–Data provisioning using BODS 4.0 (ETL Based Approach –Building AGILE Data Marts)
  • Method 3–Data provisioning using SLT
  • Method 4–Data provisioning using Direct Extractor Connection (DCX)
• Information Modeling
  • Data Modeling Fundamentals
  • Purpose of Data / Information Modeler
  • Attribute Views, Analytic Views, and Calculation Views
  • Creating Attribute Views, Analytical Views, Calculation Views for different scenarios
  • Using Hierarchies (Level Based and Parent-Child Hierarchies)
  • Creating Restricted and Calculated Measures
  • Filter Operations, Variables, and input parameters
• SQL and SQL Scripting
  • SAP HANA SQL Introduction
  • SQL Script and Procedures
  • Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential, and Union)
  • Managing Modeling Content
  • Manage Schemas
  • SAP HANA Reporting
  • Overview (BOBJ)
  • BO WEBiBO
  • Crystal Reports
  • Enterprise
  • BO IDT (BO UNX)
  • BO CMC (Admin-SSO)
  • BO AO (Analysis Office)
  • BO Design Studio
• Important Rules of Model Validation
  • Managing and processing of models
  • Rules of model validation
  • Understanding referencing to Model
  • Deploying auto documentation and learning about delivery units.
• User Management
  • Creation of Users
  • Creation of Roles
  • Creation of Role Hierarchy
  • Assignment of Users to Roles
  • Authentication
  • IMCE Authorizations
• HANA for data migration (use case)
  • Example of relevancy
  • Transformation through Calculation view
  • Example of relevancy
  • Transformation through Calculation view
  • Checking config before creating a load file
  • Checking if data exists in a target (target duplicate)