Course Code: bespokesapp
Duration: 14 hours
Prerequisites:
  • An understanding of ___.
  • Experience with ___.
  • ___ programming experience.

Audience

  • ___
  • ___
  • ___
Course Outline:

Introduction to SAP HANA

Hardware Innovations

Software Innovations

Implementation Scenarios for SAP HANA

Architecture illustrations & HANA offerings from SAP & ecosystem

SAP HANA Architecture

SAP HANA Modeling

General Modeling Principles

Tools and Components of Modeling

Data Modeling In HANA

    • Choice of Model
    • SAP HANA Models and Persistency
    • Modeling Views in HANA
    • Model Capability Map

General Modeling Guidelines

    • Best practices

On Line Analytical Processing

    • Definition
    • Usage

Joins (hands-on)

    • Types
    • Cardinalities

Creating Information Views (hands-on)

    • Attribute View
    • Analytical View
    • Calculation View
      • Graphical
      • Scripted

Advanced Scenarios (hands-on)

    • Calculated Columns
    • Currency Conversion
    • Parameters/Variables

 

Using SQL in Models

    • Introducing SAP HANA SQL
    • Working with SQLScript
    • Query a Modeled Hierarchy Using SQLScript
    • Creating and Using Functions
    • Creating and Using Procedures

Reporting on SAP HANA

The drivers

JDBC

ODBC

ODBO

Information Design Tool

    • Connections and Data Foundations
    • Building Universes for SAP HANA
    • Formatting Business Layer Objects
    • Create Universe using Information Design Tool
    • SAP HANA Business Layer

SAP HANA Interfaces to BI Client Tools

    • Webi
    • Lumira
    • Crystal Report

Introduction to SAP Activate implementation methodology

    • The Discover Phase
    • The Prepare Phase
    • The Explore Phase
    • The Realize Phase
    • The Deploy Phase
    • The Run Phase