SAP HANA Implementation, Modelling and Reporting Course

Configure and start the Hana database within a VM, managing memory constraints and prompts as you log in, set passwords, and initialize web services.

Mount your SAP HANA database on WebIDE by mounting the system database and an optional tenant. Log in with the system user to view schemas.

demonstrates an inner join between products and business partners in a one-to-many relationship, producing 106 rows and illustrating primary and foreign keys guiding the join.

Explore referential joins in Hana, inner joins with special characteristics, and prerequisites like central table maintaining referential integrity and one-to-n cardinality toward transaction tables.

Create a partner dimension calculation view by projecting and left outer joining business partner and address tables, then define calculated column Firm name by concatenating company name and legal form.

Build a SAP HANA purchase queue by creating a calculation view with a star join that blends purchase order header and item with employee and product dimensions.

Create a remote source in the SAP HANA catalog using the Hana adapter, name it Hana DB, configure the host, port, instance number, and credentials, then finalize the remote source.

Configure your SAP HANA environment by creating a remote connection, a virtual table, and the Gruntfile, then import and run pre-built SGI flow graphs FG1 and FG2.

Execute a projection on the book transaction data by adding quarter and day name columns, removing unused fields, and applying a year filter to isolate 2010 reporting.

Join the union and the transaction data with a join node, using an inner join on customer ID, and output to cube_join staging table for multi-dimensional analysis.

Apply an aggregate transform to roll up measures for reporting, filter by country, and produce customer-level totals via the join node.

Create a Berlin-filtered subset of the customer table in the split schema, then implement change data capture in SAP HANA to track and preserve history.

Set up capture table with a CDS artifact to capture changes from customer table, preserving history, using a surrogate key plus a composite key, record type, change time, and validity.

Import data and views into the same project by creating data and models folders, importing merge sales order 2014 and 2015 tables, and building and previewing HDI artifacts and views.

Configure currency conversion for a selected column by assigning semantics to amount with currency code, using the conversion tables, and set the target currency via input parameter (default USD).

Learn to implement a spatial join on geo data by joining an address table on the point spatial column using equals predicate in a SAP HANA calculation view.

Navigate the performance analysis mode to review source table details and join validations, and identify warnings about calculated columns or filters that affect performance.

Use debug mode to simulate the application level query, inspect data and intermediate results, and understand column pruning across calculation views and their dependent views.

Discover how avoiding unnecessary joins in SAP HANA reporting—by pruning unused columns and using explain plan—dramatically improves query performance.

Explore data lineage to trace how a view's data flows from source tables and cubes through semantics and columns, enabling impact analysis and troubleshooting.

Explore how the current security layout controls access to SAP HANA artifacts, showing the roles of system and technical users, HDI, privileges, and the consumption point from the tenant.

Learn the essentials of version control and model operation with git for Hana database projects, including setting up local and remote repositories, merging changes, and pushing updates to environments.

Learn to set up a new project, initialize a local git repository, and manage commits using the git pane and history in a SAP HANA database environment.

Learn how to create a local branch, commit changes, and merge them into the master branch in a Git workflow, illustrating branch isolation, merging, and history tracking.

Create a new SAP HANA project, connect a local repository to a remote GitHub repository, then commit, fetch, and merge to import calculation views and MTA files.

Push local changes to remote repository after committing updates to the XML file, demonstrating version control with commit and push and reflecting email v1 and last name v1 on GitHub.