Loader
whatsapp

TRAINING

Enroll Now sap-hana-training

Online Training

Corporate Training

ON Demand

SAP HANA Training  

SAP HANA is the in-memory computing platform that lets you accelerate business processes, deliver more business intelligence, and simplify your IT environment. By providing the foundation for all your data needs, SAP HANA removes the burden of maintaining separate legacy systems and siloed data, so you can run live and make better business decisions in the new digital economy.

How does SAP HANA work?

SAP HANA combines an ACID-compliant database with application services, high-speed analytics, and flexible data acquisition tools in a single, in-memory platform. As an in-memory database, SAP HANA stores and retrieves data used by applications. It can also act as a modern-day warehouse, integrating data from a wide variety of data sources with live transactional data to deliver up-to-date insights. Built-in application services support the development and deployment of new business apps that exploit data from the digital highway and leverage advanced data processing – text search and analytics, predictive analytics, spatial data processing, graph data processing, and streaming analytics – to deliver deeper insight from Big Data and the Internet of Things at unprecedented speed

SAP HANA Course Content

SAP HANA Studio

Modeler, Administration View, Navigator, System Monitor

 Architecture of SAP HANA

  • Row Store
  • Column Store
  • Database engine of HANA
  • Data modeling
  • Reporting
  • Architecture
  • Administration

  Modeling in SAP HANA

  • Create Attribute Views
  • Design Analytical Views
  • Create Calculation Views from multiple analytical Views
  • Best Practices while Creating Information Models
  • Performance Optimization techniques in SAP HANA
  • Currency Conversion
  • Variables in HANA
  • Meta data import to SAP HANA Using SAP BODS
  • Export Models
  • Import Models
  • SQL Script
  • CE Functions

Hierarchies – Level Based Hierarchies and Parent Child Hierarchies Restricted Measures & Calculated Measures & Calculated Attributes Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join & cardinalities

 Auto Documentation of Information Models

Reporting

SAP BI BO 4.0 Reporting Tools connectivity with SAP HANA

IMCE Clients – ODBO , ODBC, JDBC, BICS

Microsoft Excel 2010 Connection to HDB

Create Universe through Information Design Tool using JDBC Connections.

Web Intelligence Document on SAP HANA Universe

  • Design studio
  • Lumira
  • BO Analysis for Office
  • BO Analysis for OLAP
  • BO Explorer
  • Crystal Reports for enterprise

 Data Provisioning or Data Loading

  • SAP LANDSCAPE Transformation – SLT
  • SAP BODS Load to SAP HANA – ODP Enabled
  • Data Sources
  • SAP DXC – Direct Extractor Connection
  • Flat File Upload to SAP HANA
  • SAP BODS : Overview Data Services Workbench and Designer
  • Creating Data store for ECC and HANA

  Administration in SAP HANA

  • Backup & recovery
  • SAP HANA Studio Installation and Configuration
  • Clients installation
  • Create ODBC Connections
  • Monitor HDB
  • Multi Version Concurrency Control – MVCC
  • IMDB Installation

 User Management & Security

  • Distributed System Handling – Cold backup and Hot Backup
  • Persistency Layer
  • Creating Users
  • Creating Roles
  • Assign privileges to Users/Roles
  • Template Roles
  • SQL Statements for user management
  • Analytical Privileges, Package Privileges, System Privileges, SQL Privileges

  COPA Accelerator

  • COPA Overview COPA Reporting in HANA
  • Architecture for CO – PA Accelerator , Use Case Scenarios , Scope
  • DBSL – Database Shared Library Connection for HANA as secondary Database
  • SLT Replication – SAP HANA Model

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services