Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

SAP HANA Modeling (HA300)

Participants will gain knowledge about the management of modeling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modeling context.

GK# 0707 Vendor# HA300v12

Course Overview

TOP

This course teaches the core capabilities of SAP HANA for modeling, and covers mainly Graphical modeling, which is illustrated by the SAP HANA Live virtual data model, as well as SQL-based modeling, mainly table functions and procedures, with a focus on performance. It also introduces Core Data Services as a flexible method to model a persistence layer.

  • The participants will gain knowledge about the management of modeling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modeling context.
  • We also provide an overview of advanced data processing in the areas of text, spatial, predictive and graph modeling.
  • This course is built to be suitable for release HANA 1.0 SPS12 and also HANA 2.0 SPS01 audiences.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Develop information models following SAP best practices for maximum performance and flexibility
  • Get started with SQL and SQLScript based modeling
  • Manage projects and modeling content in the Web IDE
  • Implement security and data access controls around SAP HANA data models
  • Get started with advanced data processing such as text, spatial, predictive and graph
  • Most activities in this course rely on the SAP Web IDE for SAP HANA, but graphical modeling in SAP HANA Studio is also covered with a dedicated unit.

Outline

TOP
Viewing outline for:

Classroom Live Outline

  • Information Views
    • Connect Tables
    • Create Dimension and Cube Calculation View
  • Modeling Functions¬†
    • Create Hierarchies
    • Create Calculated and Restricted Columns
    • Filter Data
    • Use Variables and Input Parameters
    • Implement Currency Conversion
  • SAP HANA Studio Modeling
  • Virtual Data Models in SAP HANA
    • Use SAP HANA Live
    • Overview of Virtual Data Models built with Core Data Services (CDS)
  • SQL Script and Procedures
    • Introduce SQL and SQLScript
    • Create a Persistence Layer Using CDS
    • Create Table Functions and Procedures
  • Management and administration of Models
    • Work with Modeling Content
    • Create and Manage Projects
    • Overview of classical models migration to Web IDE
  • Security in SAP HANA Modeling
    • Understand the Key Concepts of SAP HANA Security
    • Define Data Access Security
    • Define Roles
  • Optimization of Models
    • Apply Best Practices to Model Design
    • Introduction to Performance and Analysis Tools
  • Overview of Text, Spatial, Predictive and Graph Modeling

Prerequisites

TOP

Who Should Attend

TOP
  • Business application consultants
  • Data consultants / managers
  • Database administrators
  • Application developers
  • BI specialists

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 5 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.
Enroll