SAP HANA 2.0 Modelling Masterclass |Hands On Training

Explore information views in SAP HANA, comparing graphical calculation views with table functions, and learn how dimension, cube, and cube with star join handle master and transaction data.

Create the first dimension calculation view in SAP HANA, mapping the product table to a dimension projection, renaming fields, and enabling data previews and semantic nodes.

Explore the difference between parameters and variables in SAP HANA 2.0 modeling, with free-flowing parameters and column-attached variables like country codes, plus session and system defined variables.

Explore creating and using an input parameter in a calc view, including mandatory settings and defaults, and build a calculate column that uses the parameter to produce live results.

Create input parameters and variables, attach variables to a column, choose value intervals or ranges, and set defaults, filters, and conversion functions, then use session variables to build calculate column.

Learn fuzzy search in SAP HANA 2.0 modelling masterclass: add a search parameter to view, attach it to product ID, and set a 0–1 match threshold to refine filtered results.

Explore parental (parent-child) hierarchies and level hierarchies and learn how to model multi-level data structures in SAP HANA 2.0 using real-world examples.

Learn how level hierarchy and parent-child hierarchy organize data, from product categories to products and regions, enabling drill-down reporting and city and country-level revenue insights.

Master inner, left, right, and full joins in SAP HANA with practical examples, and explore referential, text, temporal, and spatial joins for multilingual and time-dependent data.

Learn to join product category and text data in SAP HANA, using language-aware many-to-one joins and inner joins. Deploy and preview the locale-specific descriptions.

Create a cube calculation view from sales order item data, defining currency and quantity semantics for gross and net amounts, then join product master data and preview results.

Practice loading the zip file, create a dimension-type calculation view for business partner, and map fields to build a basic dimension view.

Build a dimension calculation view for business partner by importing files, mapping table fields, and building a projection to preview partner data.

Create a time dimension by building a time table with Gregorian calendar, day-level granularity, and data from 2015 to 2030, then map and preview date, month, week, and year data.

Build a star-join cube calculation view in SAP HANA by loading sales, product, time, and partner data, mapping a q-type view to fact table and dimensions, with semantics and preview.

Use calculated column, restricted column, and counter to compute profit and gross amount with currency semantics and validation. Restrict data by region (US, APJ, EMEA) to analyze sales across categories.

Learn to implement currency conversion in SAP HANA 2.0 by using conversion tables, defining a currency measure, applying exchange rates, and enabling user-specified target currencies with input parameters.

Explore SAP HANA 2.0 modelling joins by building a calculation view with supplier, customer, and country tables, implementing inner, left outer, right outer, and full outer joins, plus referential joins.

Explore referential join design in SAP HANA 2.0, understanding left, right, and both options, integrity constraints, and how cardinality, such as one-to-one, one-to-many, and many-to-many, drives optimized joins.

Explore how non equi joins work in SAP HANA modeling by creating a calculation view to identify suppliers not present in focus countries and reveal gaps.

Learn to use the minus node in SAP HANA 2.0 modelling to find suppliers not yet customers by subtracting one table from another, with mapping and projection steps.

Learn how the intersect node finds common supplier and customer names, producing a distinct inner join result, and how to map and preview the intersect output.

Explore union in a SAP HANA calculation view to stack similar data from multiple sources, auto-map fields, and differentiate Oracle and SAP data with a flag, then optimize with constraints.

Explore union behaviour in SAP HANA 2.0 modelling, including union phase data handling with raw with constant and row with constraint across projections.

this lecture demonstrates building a calculation view using multijoin to combine three tables, explains inside-out and outside-in join orders, and shows how to map fields and preview data.

Explore the theory behind table functions, scalar functions, and procedures in SAP HANA 2.0, compare their return types and usage, and introduce SQLScript used for data manipulation.

Create a scalar function in SAP HANA 2.0 modelling masterclass using scalar script, define parameters, and call it from a select query to calculate profit from gross amount.

Learn to build a SAP HANA table function that returns a table, map input parameters, and use it in a calculation view to filter sales orders.

Learn to create and call a read-only procedure in SAP HANA 2.0, define input and output parameters, and optimize performance through read-only behavior.

Explore ranking in a SAP HANA 2.0 calculation view, using rank, row, dense rank, and offset with partitioning and dynamic partitioning for sales orders.

Aggregate by sales org and product ID before ranking in a new calculation view to identify top product ideas by gross amount, using top percentages and rank partitions.

Split large models into small views to keep calculations manageable. Strive for query unfolding into a single SQL statement, and prune early using scale engine, cardinality, and referential design.

Learn how to use performance analysis in SAP HANA to validate joins and cardinality, inspect calculation views, and optimize modeling with design-time suggestions and threshold settings.

Explore explain plan and scale analysis in SAP HANA to assess backend operators and plan graphs for optimizing query performance.

Debug SAP HANA 2.0 models using the debug view, semantics, and design-time builds to inspect queries, grouping, aggregation, per-node execution, and data filtering.