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.

Edit the Windows hosts file to map the Hana server IP, then test by logging into Web IDE as admin and verifying the landing page.

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.

Map the development space to a specific tenant database to avoid defaulting to the system db and ensure artifacts persist in the designated tenant, such as ZK, via HDI.

Jump into Hana modeling by exploring dimensions, facts, and cube concepts, then build your first purchase insights cube using curated data, joins, and semantic layer exploration.

Access the SAP HANA Web IDE, verify the HANA database runs on GCP, authenticate via the URL with admin and the master password, and explore workspace and the database explorer.

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.

Learn left outer join theory and hands-on practice by joining address and business partner tables in Hana to see how the left table drives matches and nulls.

Explore full outer join theory and hands-on practice with SAP HANA, linking address and business partner data to reveal matches and missing information.

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 standard dimension calculation view for employees in SAP HANA, selecting required columns, setting employee ID as the key, then build, save, and preview the data.

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.

Create a hybrid dimension calculation view by joining a products table and a partners view, projecting all columns, and filtering to the EMEA region.

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.

Log in to the HANA server, free memory to install SDI components, download and install the HDI, then validate by running an empty project in the Web IDE.

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.

Create an MTA-based SAP HANA project for ETL, add a HANA database module, build an HDI container with the template’s UI components, then mount and explore it in the workspace.

Set up a UI service to connect a tenant to the HDI by creating a user provider with driver, username, and password, then save to establish the connection.

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.

The course demonstrates building a base cube in an HDI project, showing staging tables, projection, region-based slicing, unions, joins, and aggregations of customer and transaction data.

Create a subfolder in the ETL flow and a flow graph FG1 to project, cleanse addresses in HDI data, and create a discount abs column, then write a template table.

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.

Apply a case transform to split data by regions and route us, fr, and default outputs to separate targets. Test with projections and truncate settings to verify segmentation.

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.

Explore change data capture for maintaining master data like customers, with a projection node and table comparison to capture inserts, updates, deletes and history for compliance.

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.

Create a namespace at the ETL flows level to organize project artifacts in per-project subfolders, persist changes, and build the project to ensure the correct folder path and ignored subfolders.

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.

Use history preserving for CDC to track insertions and updates with a status flag and valid from and valid to dates, capturing new and old records during each data change.

Develop the second modeling project for the sales insights use case, build the sales insights cube with a layered approach using dimension and cube calculation views, and complete a quiz.

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.

Create a dimension calculation view that joins address and business partner data in the HDI, projecting all columns with a 1-to-1 inner join and validating via data preview.

Create a 2014 cube calculation view by projecting 2014 transaction data, joining with a business partner dimension, mapping columns, adding a year calculated column, and validating with data preview.

Create a calculation view to union 2014 and 2015 cubes, auto map by name, designate quantity, tax amount, net amount, and gross amount as measures, then preview the merged data.

Create an input parameter to capture the user’s currency choice, set as mandatory with a direct value and a default of USD, and preview data before binding for currency conversion.

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).

Build the ranking feature to identify top and bottom performers across country, region, or product line, explore absolute values and percentages, and experiment with rank, dense rank, and row aggregations.

Create and configure a rank node from a cube source, selecting country and gross amount, and apply absolute rank with top five, generating a score column partitioned by country.

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.

Explore model optimization and accuracy in SAP HANA, using performance analysis tools, explain plans, and data lineage to reduce data vertically and horizontally, avoid unnecessary joins, and maintain accurate results.

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.

Explore explain plan to see how the Hana database will execute a query, including operator details, source data, output size, and execution cost, with plan and connection IDs for analysis.

Explore SAP HANA visualize plan to analyze SQL performance, drill into operator-level bottlenecks, data flow, and costs, and optimize query structure using logical and physical plan insights.

Demonstrates vertical and horizontal filtering, reducing columns and rows, to boost query performance, lowering time from about 300 ms to ~37 ms, with plan graph insights.

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

Learn to boost performance with union pruning by implementing a constant hinting column in a 2014–2015 union, enabling where-clause filtering to skip unnecessary data and reduce joins.

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.

Learn the SAP HANA 2.0 security model by focusing on securing models in your schema, understanding three key user types, and applying object, system, and analytical privileges through roles.

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.

Create a new user in the SAP HANA cockpit, enforce first-login password change, and assign schema privileges and a role to enable scoped access.

Create a role named access schema to grant select and execute privileges on an HDI schema, assign the role to the user, and verify access by viewing tables and data.

Create and assign an analytic privilege named ana sec to a runtime role, then test access to ensure a user sees only EMEA data in the cube.

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.

Create and track simple test files, stage and commit changes with clear messages, and review history to understand versioning and comparisons in the main branch of a local git repository.

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.