651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

SAP HANA 2.0 SPS06 Modeling

5 Days

Description

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.

Goals

This course will prepare you to:

  • Develop information models following SAP best practices for maximum performance and flexibility
  • Get started with SQL and SQL-Script based modeling
  • Manage projects and modeling content in the SAP Web IDE for SAP HANA
  • Implement security and data access controls around SAP HANA data models

Audience

  • Application Consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application Developer
  • BI specialist

Upcoming Classes

Virtual Classroom Live
June 03, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Virtual Classroom Live
September 23, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Virtual Classroom Live
December 09, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • Calculation Views
    • Introducing Calculation Views
    • Understanding the Different Types of Views
    • Working with Common View Design Features
  • Using Nodes in Calculation Views
    • Using Projection Nodes
    • Using Join Nodes
    • Working with Data Sets
    • Aggregating Data
    • Creating CUBE with Star Join Calculation Views
    • Extracting Top Values with Rank Nodes
  • Modeling Functions
    • Create Restricted and Calculated Columns
    • Filtering Data
    • Using Variables and Input Parameters
    • Implementing Hierarchies
    • Implement Currency Conversion
    • Defining Time-Based Dimension Calculation Views
  • Using SQL in Models
    • Introducing SAP HANA SQL
    • Query a Modeled Hierarchy Using SQLScript
    • Working with SQLScript
    • Creating and Using Functions
    • Creating and Using Procedures
  • Persistence Layer
    • Defining the Persistence Layer
    • Loading Data into Tables
    • Accessing Remote Data
  • Optimization of Models
    • Implementing Good Modeling Practices
    • Implementing Static Cache
    • Controlling Parallelization
    • Implementing Union Pruning
    • Using Tools to Check Model Performance
    • Developing a Data Management Architecture
  • Management and administration of Models
    • Working with Modeling Content in a Project
    • Creating and Managing Projects
    • Enabling Access to External Data
    • Working with GIT Within the SAP Web IDE
    • Migrating Modeling Content
  • Security in SAP HANA Modeling
    • Understanding Roles and Privileges
    • Defining Analytic Privileges
    • Defining Roles
    • Masking Sensitive Data
    • Anonymizing Data

Upcoming Classes

Virtual Classroom Live
June 03, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Virtual Classroom Live
September 23, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Virtual Classroom Live
December 09, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

 

Essential

  • HA100 SAP HANA - 360° Introduction

Recommended

  • HA150 SAP HANA 2.0 SPS06 - SQLScript for SAP HANA

Upcoming Classes

Virtual Classroom Live
June 03, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Virtual Classroom Live
September 23, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Virtual Classroom Live
December 09, 2024

$4,300.00
5 Days    9:30 AM ET - 5:30 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date