SAP HANA Modelling is an activity in which users refine or slice data in the database table by creating information views based on the business scenario. In this course delegates learn how to create these views so they can be used for reporting and decision-making purposes.

To be successful in this training course you must attend 1 day HANA Introduction course, understand SAP BW modelling concepts (recommended).

HANA Modelling Training Audience:

This training course is ideal for SAP Consultants, Data Analyst, Business Analyst, BI specialists and Data Scientists. The course is suitable for anybody who needs high level view of HANA modelling, suitable for anyone who wants to make a career in SAP HANA.

By the end of the training course delegates will understand concepts of HANA information views, get started with SQL scripting and work with standard Info Views.

SAP HANA Modelling Attribute View

  • How to connect tables using:
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Text Join
  • Referential Join
  • Union
  • Filter
  • Calculated Column
  • Creating Hierarchies

Analytic View

  • Calculated Attribute
  • Calculated Measure
  • Restricted Measure
  • Variables
  • Parameters

Calculation View

  • Creating Calculation View- Data category Dimension
  • Creating Calculation View- Data category Cube
  • Creating Calculation View- Data category Cube with Star Join
  • Using Nodes
  • Union
  • Join
  • Projection
  • Aggregate
  • Rank
  • Star Join

Decision Table

  • Creating Decision Table
  • Calling Decision Table

HANA SQL Introduction (Overview)

  • DDL Statements
  • DML Statements
  • DCL Statements
  • Creating Table
  • Calling View
  • Creating Schema
  • Calling Grant Statement
  • CE functions

Please complete this form and we'll be in touch

Hide form
Please enter a date or timescale
Please type in a preferred location or region...