Lab Activity - Exercise - Implement Union Pruning in a Calculation

SAP Native HANA Training

Follow our LinkedIn SAP Learner Community for a lot of Free Content

SAP Learner Community of LinkedIn

Session 1 - Introduction to HANA Architecture

Session Video - Introduction to HANA Architecture (83:46)
Assessment - Introduction to HANA Architecture
Quiz

Session 2 - Using different nodes in calculation view

Session Video - Using different nodes in calculation view (90:52)
Assessment - Using different nodes in calculation view
Quiz

Session 3 - Create restricted and calculated columns, filtering data

Session VIideo - Create restricted and calculated columns, filtering data (106:14)
Assessment - Create restricted and calculated columns, filtering data
Quiz

Session 4 - Implementing Hierarchies, Introducing SAP HANA SQL

Session Video - Implementing Hierarchies, Introducing SAP HANA SQL (90:47)
Assessment - Implementing Hierarchies, Introducing SAP HANA SQL
Quiz

Session 5 - Implementing Hierarchies, Introducing SAP HANA SQL (Hands On)

Session Video - Implementing Hierarchies, Introducing SAP HANA SQL (Hands On) (95:07)
Assessment - Implementing Hierarchies, Introducing SAP HANA SQL (Hands On)
Quiz

Session 6 - W3School, Creating & Using Scalar function, Virtual Table creation

Session Video - W3School, Creating & Using Scalar function, Virtual Table creation (90:51)
Assessment - W3School, Creating & Using Scalar function, Virtual Table creation
Quiz

Session 7 - Creating and Using Procedures & Debugging of Stored procedures, Declarative Logic & Imperative Logic

Session Video - Creating and Using Procedures & Debugging of Stored procedures, Declarative Logic & Imperative Logic (99:29)
Assessment - Creating and Using Procedures & Debugging of Stored procedures, Declara
Quiz

Session 8 - Data load: Flat file data update, SQL practice, Table function creation

Session Video - Data load: Flat file data update, SQL practice, Table function creation (149:54)
Assessment - Data load Flat file data update, SQL practice, Table function creation
Quiz

Session 9 - Data insert with Flat file update, Window functions, start of table function, SQL COALESCE function

Session Video - Data insert with Flat file update, Window functions, start of table function, SQL COALESCE function (95:14)
Assessment - Data insert with Flat file update, Window functions, start of table function, SQL COALESCE function
Quiz

Session 10 - User-defined libraries

Session Video - User-defined libraries (32:49)
Assessment - User-defined libraries
Quiz

Session 11 - Lab activity calling Procedure & table function, introduction to planViz

Session Video - Lab activity calling Procedure & table function, introduction to planViz (88:30)
Assessment - Lab activity calling Procedure & table function, introduction to planV
Quiz

Session 12 - Performance analysis and best practices of SAP HANA, Implementing static cache

Session Video - Performance analysis and best practices of SAP HANA, Implementing static cache (101:57)
Assessment - Performance analysis and best practices of SAP HANA, Implementing stat
Quiz

Session 13 - Lab activities on union pruning and Different scenarios

Session Video - Lab activities on union pruning and Different scenarios (87:43)
Assessment - Lab activities on union pruning and Different scenarios
Quiz

Session 14 - Scheduling of procedures and Troubleshooting, Defining Analytical Privileges and roles

Session Video - Scheduling of procedures and Troubleshooting, Defining Analytical Privileges and roles (94:53)
Assessment - Scheduling of procedures and Troubleshooting, Defining Analytical Priv
Quiz

Session 15 - Recap

Session Video - Recap (82:27)
Session Video - Recap (67:13)
Session Video - Recap (95:30)
Session Video - Recap (81:39)
Session Video - Recap (88:12)

Assignments

Assignments - Calculation View - Star Join
Assignments - Creating Input Parameters
Assignments - Procedures
Assignments - Table Functions
Assignments - Using different Nodes in Calculation Views

Lab Activity

Lab Activity - Exercise - Access a Calculation View in Performance Analysis Mode
Lab Activity - Exercise - Audit Information Models and their Dependencies
Lab Activity - Exercise - Cascade User Prompts
Lab Activity - Exercise - Clone the SAP HANA Interactive Education (SHINE) Application from GitHub
Lab Activity - Exercise - Combine Two Data Sources with a Union Nod
Lab Activity - Exercise - Control Parallelization in a Data Flow
Lab Activity - Exercise - Control the Behavior of the Aggregation Node
Lab Activity - Exercise - Create a CUBE with Star Join Calculation View
Lab Activity - Exercise - Create a DIMENSION Calculation View
Lab Activity - Exercise - Create a Level Hierarchy
Lab Activity - Exercise - Create a New Project and an HDB Module
Lab Activity - Exercise - Create a Parent-Child Hierarchy
Lab Activity - Exercise - Create a Procedure that is Consumed by an Input Parameter
Lab Activity - Exercise - Create and Assign an Analytic Privilege
Lab Activity - Exercise - Create Restricted and Calculated Measures
Lab Activity - Exercise - Define a Data Source using a Table Function
Lab Activity - Exercise - Define a Persistence Layer
Lab Activity - Exercise - Define and Use Filters
Lab Activity - Exercise - Define Column Masking in a Calculation View
Lab Activity - Exercise - Implement a Hierarchical Value Help
Lab Activity - Exercise - Implement Currency Conversion in a Calculation View.docx
Lab Activity - Exercise - Implement External View for Value Help
Lab Activity - Exercise - Implement Union Pruning in a Calculation View
Lab Activity - Exercise - Import, Rename and Copy Models
Lab Activity - Exercise - Join Three Tables in a Single Join Node
Lab Activity - Exercise - Prepare Your SAP HANA System
Lab Activity - Exercise - Read a Hierarchy Structure with SQL
Lab Activity - Exercise - SAP Create a Cube Calculation View
Lab Activity - Exercise - Set Up a Project to Access an External Schema
Lab Activity - Exercise - Use a Minus Node in a Calculation View
Lab Activity - Exercise - Use Debug Query Mode
Lab Activity - Exercise - Use Git for Version Control in Your Local Workspace
Lab Activity - Exercise - Use Rank Nodes to Partition, Order, and Extract Values from a Data Set
Lab Activity - Exercise - Use Variables and Input Parameters
Lab Activity - Exercise - Work with SQL Statements

Configuration Guides (Downloaded from the Internet as it is available for Public Use)

Configuration Guide - Hana Native Reporting on BW Data
Configuration Guide - Native HANA
Configuration Guide - P2047 Sherkat
Configuration Guide - SAP Agent Deployment Guide - 1
Configuration Guide - SAP Agent Deployment Guide - 2
Configuration Guide - SAP Native HANA Best Practices
Configuration Guide - SAP Native HANA Modelling

Capstone Projects / Case Studies

Capstone Project - SAP Native HANA - Integrated Financial Analytics Platform for GlobalCorp Inc.
Capstone Project - SAP Native HANA - Intelligent Building Management Platform for SmartCity Inc.
Capstone Project - SAP Native HANA - Intelligent Supply Chain Management Solution for ManufacturingCorp
Capstone Project - SAP Native HANA - Omnichannel Sales Analytics Solution for RetailGiant

Interview Questions

Interview Questions - Set 1

Prepare your Linkedin profile

Linkedin Cheat Sheet

Prepare your Resume

Resume Cheat Sheet

Quiz

Test Your Knowledge

Teach online with

Lab Activity - Exercise - Implement Union Pruning in a Calculation View

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock