SAP HANA Modelling Training Course

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.

HANA20 - SAP HANA Modelling

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.

  • Duration: 4 Days
  • Dates: Please select

Goals

  • Explain what is SAP BusinessObjects Business Intelligence platform
  • Define the role of universes, classes, objects, measures, dimensions and Details.
  • Construct queries using pre-defined and ad-hoc conditions.
  • Format reports.
  • Manipulate data by applying filters, sorts, breaks calculations and ranking.
  • Create cross tabular and financial reports.
  • Generate and modify Charts.
  • Analyse data at different levels of Detail.

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.

Prerequisites

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

Locations

  • London
  • Warwick
  • Glasgow
  • Onsite at Your Office
  • Virtual

Content

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
a.       Union
b.       Join
c.       Projection
d.       Aggregate
e.       Rank
f.        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


Contact
Contact

For any questions please feel free to contact us.