ha300

HA300SAP HANA Implementation and

ModelingSAP HANA

Course OutlineCourse Version: 09Course Duration: 3 Day(s)Publication Date: 2015Publication Time:

Copyright

Copyright © SAP SE. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purposewithout the express permission of SAP SE. The information contained herein may be changedwithout prior notice.

Some software products marketed by SAP SE and its distributors contain proprietary softwarecomponents of other software vendors.

Trademarks

• Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® and SQL Server® areregistered trademarks of Microsoft Corporation.

• IBM®, DB2®, OS/2®, DB2/6000®, Parallel Sysplex®, MVS/ESA®, RS/6000®, AIX®,S/390®, AS/400®, OS/390®, and OS/400® are registered trademarks of IBM Corporation.

• ORACLE® is a registered trademark of ORACLE Corporation.• INFORMIX®-OnLine for SAP and INFORMIX® Dynamic ServerTM are registered

trademarks of Informix Software Incorporated.• UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of the Open Group.• Citrix®, the Citrix logo, ICA®, Program Neighborhood®, MetaFrame®, WinFrame®,

VideoFrame®, MultiWin® and other Citrix product names referenced herein are trademarksof Citrix Systems, Inc.

• HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, WorldWide Web Consortium, Massachusetts Institute of Technology.

• JAVA® is a registered trademark of Sun Microsystems, Inc.• JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for

technology invented and implemented by Netscape.• SAP, SAP Logo, R/2, RIVA, R/3, SAP ArchiveLink, SAP Business Workflow, WebFlow, SAP

EarlyWatch, BAPI, SAPPHIRE, Management Cockpit, mySAP.com Logo and mySAP.comare trademarks or registered trademarks of SAP SE in Germany and in several other countriesall over the world. All other products mentioned are trademarks or registered trademarks oftheir respective companies.

Disclaimer

THESEMATERIALS ARE PROVIDED BY SAP ON AN "AS IS" BASIS, AND SAP EXPRESSLYDISCLAIMS ANY AND ALL WARRANTIES, EXPRESS OR APPLIED, INCLUDINGWITHOUT LIMITATION WARRANTIES OF MERCHANTABILITY AND FITNESS FOR APARTICULAR PURPOSE, WITH RESPECT TO THESE MATERIALS AND THE SERVICE,INFORMATION, TEXT, GRAPHICS, LINKS, OR ANY OTHER MATERIALS AND PRODUCTSCONTAINED HEREIN. IN NO EVENT SHALL SAP BE LIABLE FOR ANY DIRECT,INDIRECT, SPECIAL, INCIDENTAL, CONSEQUENTIAL, OR PUNITIVE DAMAGES OF ANYKIND WHATSOEVER, INCLUDING WITHOUT LIMITATION LOST REVENUES OR LOSTPROFITS, WHICH MAY RESULT FROM THE USE OF THESE MATERIALS OR INCLUDEDSOFTWARE COMPONENTS.

g20151310106

HA300 Contents

ContentsCourse Overview ....................................................................... v

Course Goals .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vCourse Objectives ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v

Unit 1: Introduction to SAP HANA Modeling .................................... 1Approaching SAP HANA Modeling ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1Connecting Tables ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

Unit 2: Using Graphical Modeling Tools.......................................... 2Introduction to Information Views ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2Creating Attribute Views and Analytic Views ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2Using Hierarchies ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2Creating Restricted and Calculated Columns ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3Using Filter Operations... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3Using Variables and Input Parameters .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3Creating Graphical Calculation Views... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Unit 3: Getting Started with SQL Script and Procedures..................... 4SAP HANA SQL Introduction... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4Introduction to SQLScript . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4Creating and Using Procedures... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

Unit 4: Other Modeling Features ................................................... 5Using Currency Conversion ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5Creating Decision Tables ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5Working with Geospatial Data... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Unit 5: Using Text Search and Analysis .......................................... 6Overview of Full Text Search and Text Analysis .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6Defining Full Text Indexes ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6Using Full Text Search ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Unit 6: Managing Modeling Content ............................................... 7Processing and Analyzing Models.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7Managing Modeling Content.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

2015 © SAP SE. All rights reserved. iii

HA300 Contents

Unit 7: Security and Authorizations ............................................... 8Users, Roles, and Privileges ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8Defining Privileges ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Unit 8: Introduction to the Application Function Library ..................... 9Application Function Library .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

2015 © SAP SE. All rights reserved. iv

HA300 Course Overview

Course OverviewThis course is for consultants, project team members, and data modelers who want to optimizereporting performance using SAP HANA. It builds on the introduction provided in the HA100or HA100e course, and deals with more advanced modeling and structuring techniques.

You will also learn how to maintain security and authorizations, how to manage modelingcontent, and how to use the powerful text analysis features of SAP HANA.

The course will also give you an overview of the Application Function Library.

Target AudienceThis course is intended for the following audiences:

• SAP HANA Application Consultants• Project team members• Data Modeling Consultants

Course PrerequisitesRequired Knowledge

• Basic knowledge of SAP HANA• The HA100 course provides a good understanding of SAP HANA and it is mandatory for

participants who want to attend this course.

Recommended Knowledge

• Basic knowledge of row and column table storage• First experience in data modeling• Basic SQL knowledge• Basic understanding of SAP Business Objects BI products

Course GoalsThis course will prepare the participant to:

• Implement information models with the SAP HANA Studio• Define the security from a modeler’s perspective

Course ObjectivesAfter completing this course, the participant will be able to:

• Create data models in SAP HANA• Understand the difference between SAP HANA views

2015 © SAP SE. All rights reserved. v

HA300 Course Overview

• Ensure best performance of reporting through an optimized data model• Manage modeling content• Use text analysis features• Maintain security and authorizations• Get an overview of the Application Function Library

2015 © SAP SE. All rights reserved. vi

HA300 Course Outline

Unit 1Introduction to SAP HANA Modeling

Unit OverviewThis unit will introduce some important considerations that you must have before creatinginformation models in SAP HANA. In particular, you will review the main criteria that helpyou to choose the most relevant type of information model and understand how the differentSAP HANA engines share the tasks when they execute an information model. You will alsolearn several best practices in order to build high-performance information models.

Additionally, you will review the different join types that SAP HANA supports, and knowhow to use them in the information views that you will create.

Lesson: Approaching SAP HANA ModelingLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Take into account persistency considerations• Explain the different engine types in the SAP HANA architecture• Choose the best views for the Information Model• Discuss general modeling recommendations

Lesson: Connecting TablesLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Explain differences between the SAP HANA join types• Know when to use which type of join when connecting tables• Explain how to use union on datasets, and union with constant values

2015 © SAP SE. All rights reserved. 1


Unit 2Using Graphical Modeling Tools

Unit OverviewThis unit will give you a good knowledge on how to use the graphical SAP HANA modelingfunctionality to create several types of Information Models. You will build Attribute Views,Analytic Views and Calculation Views. You will also work with hierarchies, create calculatedand restricted columns, and define variables and input parameters.

Lesson: Introduction to Information ViewsLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Understand the different types of information views• Explain how to model a Star Schema-like view with Analytic

Views and Attribute Views• Decide whether you must use a Calculation View

Lesson: Creating Attribute Views and Analytic ViewsLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Create Attribute Views• Create derived attribute views• Define calculated attributes• Create time-based attribute views• Create stand alone text tables• Use base table aliases• Define Label Columns and hide attributes in an attribute view

Lesson: Using HierarchiesLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Implement level hierarchies



• Create parent-child hierarchies

Lesson: Creating Restricted and Calculated ColumnsLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Understand the benefits of Restricted Columns and Calculated Columns• Create Restricted Columns• Create Calculated Columns

Lesson: Using Filter OperationsLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Understand the difference between Filters and WHERE clauses• Create client dependent views• Restricting data when modeling using domain fix values

Lesson: Using Variables and Input ParametersLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Explain the difference between variables and input parameters• Create variables and use them to filter data• Create input parameters

Lesson: Creating Graphical Calculation ViewsLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Describe the different types of Calculation Views• Explain the benefits of each type of node in calculation views• Create and combine nodes in Calculation views in the most relevant way• Use Calculation Views specific features to enhance the flexibility of this type of view



Unit 3Getting Started with SQL Script and

ProceduresUnit OverviewThis unit will give you an introduction to the Structured Query Language (SQL), that is usedas the main language to manipulate the SAP HANA database objects and data. You will alsolearn about SQL Script, a collection of extensions to the standard SQL, and how to use SQLScript to define additional data types, functions and procedures that you can use, for example,in Calculation Views.

Lesson: SAP HANA SQL IntroductionLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Explain the language elements used in SAP HANA SQL statements.

Lesson: Introduction to SQLScriptLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Define SQLScript and SQLScript extensions• Understand the SQLScript implementation logic• Explain calculation engine and calculation model• Describe the Calculation Engine plan operators

Lesson: Creating and Using ProceduresLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Understand the benefits of procedures• Create a procedure• Call a procedure



Unit 4Other Modeling Features

Unit OverviewThis unit will cover some advanced modeling features, such as currency conversion, DecisionTables, and Geospatial data types.

Lesson: Using Currency ConversionLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Understand Currency Conversion in SAP HANA• Apply Currency Conversion in Analytic Views• Leverage Fixed Currencies• Leverage Source Currency from Columns• Create Target Currency Variables• Use Currency Conversion in Calculation Views

Lesson: Creating Decision TablesLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Understand decision automation using Business Rules on SAP HANA• Understand how Decision Tables can help driving business agility• Create Decision Tables• Consume Decision Tables in Calculation Views

Lesson: Working with Geospatial DataLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Store geographical data in column tables• Query geographical data using SQL



Unit 5Using Text Search and Analysis

Unit OverviewThis unit will give you a basic understanding of the Full Text Search and other text analysisfeatures in SAP HANA.

Lesson: Overview of Full Text Search and Text AnalysisLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Understand the Full Text Search capabilities of SAP HANA• Invoke the text search processes• Create Fuzzy Search• Explain Text Analysis•

Lesson: Defining Full Text IndexesLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Understand the concept of Full Text index• Explain which data types can be indexed for Full Text Search• Enable columns for Full Text Search in SAP HANA tables• Implement Full Text search in SAP HANA Modesl with SAP HANA Studio

Lesson: Using Full Text SearchLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Know how to use Full Text Search• Know how to use Fuzzy Search• Understand Fuzzy Search relevance scoring• Know how to use Freestyle Search



Unit 6Managing Modeling Content

Unit OverviewThis unit will provide you with an understanding on how to process Information Modelsin a productive environment. This includes validating, comparing versions and generatingdocumentation of Information Models.

Lesson: Processing and Analyzing ModelsLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Validate Information Models• Compare different versions of an Information Model• Check model references• Generate auto documentation• Execute a Performance Analysis of an Information Model

Lesson: Managing Modeling ContentLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Manage schemas and define schema mapping• Define package-specific schema mapping• Transport information models between two systems• Move and copy information models within a system• Take over an information model edited by another user• Translate metadata texts



Unit 7Security and Authorizations

Unit OverviewIn a productive environment, the Security and Authorizations must be carefully managed. Thisunit will give you an overview of how to define users and roles and assign them privilegesin order to implement data access security and authorizations on catalog objects (schema,tables) and repository objects (packages).

The main focus will be on the Modeler role, but you will also learn how to give the relevantauthorizations to the end-users who consume data through your information models.

Lesson: Users, Roles, and PrivilegesLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Define Roles and Privileges• Explain how Users, Roles and Privileges are used to implement Objects

and Data Access security in an SAP HANA system

Lesson: Defining PrivilegesLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Describe the different types of privileges• Explain how to grant the relevant privileges to the Modeler and End-User



Unit 8Introduction to the Application Function

LibraryUnit OverviewThis unit provides a high level overview about the usage of the Application Function Libraryin SAP HANA

Lesson: Application Function LibraryLesson ObjectivesAfter completing this lesson, the participant will be able to:

• Have an understanding of the Application Function Library• Know when to use the Business Function Library• Know when to use the Predictive Analysis Library


ha300

Documents