In this course, students implement graphical and script-based information models, use text search and analysis, and manage and transport information models.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

This course will prepare you to:
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 a quick overview of advanced data processing such as text, spatial, predictive and graph

1

  • Information Views

  • Introducing Information Views
    Understanding the Different Types of Views
    Working with Common View Design Features
2

  • Using Nodes in Calculation Views

  • Using Projection Nodes
    Using Join Nodes
    Working with Data Sets
    Aggregating Data
    Creating Cubes with Star Join Calculation Views
    Extracting Top Values with Rank Nodes
3

  • Modeling Functions

  • Create Restricted and Calculated Columns
    Filter Data
    Use Variables and Input Parameters
    Create Hierarchies
    Implement Currency Conversion
4

  • Using SQL in Models

  • Introducing SAP HANA SQL
    Working with SQLScript
    Query a Modeled Hierarchy Using SQLScript
    Creating and Using Functions
    Creating and Using Procedures
5

  • CDS in SAP HANA Modeling

  • Defining the Persistence Layer Using CDS
    Creating Views with CDS
6

  • Optimization of Models

  • Using Tools to Check Model Performance
    Implementing Good Modeling Practices
7

  • Management and administration of Models

  • Working with Modeling Content in a Project
    Creating and Manage Projects
    Enabling Access to External Data
    Working with GIT Within the SAP Web IDE
    Migrating Modeling Content
8

  • Security in SAP HANA Modeling

  • Understanding Roles and Privileges
    Defining Analytic Privileges
    Defining Roles
    Masking Sensitive Data
    Anonymizing Data
    Introduction to Advanced Modeling

Audience

This course is for those whose job role could be Business application consultant, Data Consultant / Manager, Database Administrator, Application developer, BI specialist.

Language

English

Prerequisites

HA150 – SQL and SQLScript for SAP HANA

$4,335

Length: 5.0 days (40 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
13
Nov
Monday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Loading...