HA300: SAP HANA 2.0 SPS07 Modeling

Course Information

Course Name

HA300: SAP HANA 2.0 SPS07 Modeling

Duration

5 Days

Overview

This course teaches the core capabilities of SAP HANA for calculation view modeling, and covers mainly graphical modeling, as well as SQL- based modeling (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.

Audience Profile

• Application Consultant

• Data Consultant / Manager

• Database Administrator

• Application Developer

• BI specialist

Prerequisites

Essential

• HA100 SAP HANA – 360° Introduction

Recommended

• HA150 SAP HANA 2.0 SPS07 – SQLScript for SAP HANA

At Course Completion

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

Course Outline

Module 1: Preparing the Modeling Environment

• Getting Started with SAP Web IDE for SAP HANA

• Importing an Existing Project in SAP Web IDE for SAP HANA

       Module 2: Creating Calculation Views

• Understanding Basic Concepts and Terminology

• Checking the Output of a Calculation View

• Creating Dimension Calculation Views

• Creating Cube Calculation Views

• Creating SQL Access Only Calculation Views

• Choosing a Data Source for a Calculation View

Module 3: Working with Common Features of Calculation Views

Module 4: Defining the Top View Node

Module 5: Working with Common Nodes in Calculation Views

• Using Projection Nodes

• Working with Aggregation Nodes

Module 6: Joining Data Sources in Calculation Views

• Combining data sources using a join node

• Joining more than two tables in a single join node

• Creating Cube with Star Join Calculation Views

• Configuring non-equi joins

• Preventing incorrect aggregations using a dynamic join

• Filtering on Join Nodes

• Optimizing Joins

Module 7: Working with Union Nodes in Calculation Views

• Working with the Union Node

Module 8: Creating Data Slices

• Implementing Minus and Intersect Nodes

Module 9: Ranking Data

• Implementing Rank Nodes

Module 10: Embedding Functions in Calculation Views                                             

• Generating Restricted Columns

• Generating Calculated Columns

• Filtering Data

• Implementing Currency Conversion

Module 11: Creating Dynamic Calculation Views

• Implementing Variables

• Defining Value Help Views

• Implementing Input Parameters

• Mapping Variables and Input Parameters

Module 12: Implementing Hierarchies in Calculation Views

• Modeling Hierarchies

• Creating Time-Based Dimension Calculation Views

• Using a Hierarchy for Value Help

Module 13: Developing Custom Logic using SQL

• Introducing SAP HANA SQL Console

• Implementing SQL in Calculation Views

• Querying a Modeled Hierarchy Using SQL

• Working with SQLScript

• Creating and Using Functions

• Creating and Using Procedures

Module 14: Applying Best Practices for Modeling

• Implementing Recommended Modeling Practices

• Implementing Best Practices in Calculation View Nodes

Module 15: Using Tools to Check Model Performance

• Validating Calculation Views with Performance Analysis Mode

• Debugging Calculation Views with the Debug Query Mode

• Analyzing executions with the SQL Analyze

Module 16: Implementing Features to Improve Performance

• Implementing Union Pruning

• Controlling Parallelization

• Partitioning Tables

Module 17: Storing Calculation View Results

• Implementing Static Cache to Improve Performance

• Creating Snapshots

Module 18: Using Additional Modeling Productivity Tools

• Developing Calculation views more efficiently

• Working with Modeling Content in a Project

Module 19: Working in a Modeling Project

• Explaining the Project Structure

• Building Models

• Managing modeling content

Module 20: Managing the Lifecycle of a Modeling Project

• Creating a Project

• Enabling Access to External Data

• Using Git to Manage Source Code

• Deploying an application

• Migrating Modeling Content

Module 21: Implementing Security in SAP HANA Modeling

• Defining Analytic Privileges

• Defining Roles

• Masking Sensitive Data

• Anonymizing Data

All SAP certification courses are conducted by certified trainers from Iverson.

Digital Methods acts as the official training partner and assists with program consultation, registration, coordination, scheduling, and administrative arrangements to ensure a seamless and professionally managed training experience.