SAP HANA Modeling (HA300v12)

  • Business application consultant
  • Data consultant / manager
  • Database administrator
  • Application developer
  • BI specialist

Prerequisite

  • Basic knowledge of SAP HANA
  • The HA100 course provides a good understanding of SAP HANA and it is mandatory for participants who want to attend this course
  • Basic knowledge of row and column table storage
  • First experience in data modeling
  • Basic SQL knowledge
  • Basic understanding of SAP Business Objects BI products

Expected Duration
5 day

Description

In this course, you will develop advanced SAP HANA modeling skills, so that you are able to create sophisticated and high performance information views, which can expose data to applications and report consumers.

This course is based on software release:

  • SAP HANA SPS12

Objective

1. Information Views

  • Connect tables
  • Create dimension and cube calculation views

2. Modeling Functions

  • Create hierarchies
  • Create calculated and restricted columns
  • Filter data
  • Use variables and input parameters
  • Implement currency conversion
  • Create decision tables

3. SQL Script and Procedures

  • Introduce SQL and sqlscript
  • Create table functions and procedures
  • Use the SQL debug tools

4. Virtual Data Models in SAP HANA

  • Use SAP HANA live
  • Virtual data models built with core data services (cds)

5. Text, Spatial, Predictive and Graph Modeling

6. Management and Administration Of Models

  • Validate information models
  • Transport information models
  • Rename, copy move models
  • Schema mapping
  • Convert deprecated modeling artifacts using migration tools

7. Security in SAP HANA Modeling

  • Key concepts of SAP HANA security
  • Data access security

8. Optimization of Models

  • Best practices to model design
  • Plan visualizer and explain plan tools

SUBSCRIPTION COST


$3,350.00

Select Course Options

 

NEED HELP OR NOT SURE?