HA300 SAP HANA 2.0 SPS06 Modeling

Introducing Calculation Views

Understanding the Different Types of Views

Working with Common View Design Features

Using Projection Nodes

Using Join Nodes

Working with Data Sets

Aggregating Data

Creating CUBE with Star Join Calculation Views

Extracting Top Values with Rank Nodes

Create Restricted and Calculated Columns

Filtering Data

Using Variables and Input Parameters

Implementing Hierarchies

Implement Currency Conversion

Defining Time-Based Dimension Calculation Views

Introducing SAP HANA SQL

Query a Modeled Hierarchy Using SQLScript

Working with SQLScript

Creating and Using Functions

Creating and Using Procedures

Defining the Persistence Layer

Loading Data into Tables

Accessing Remote Data

Implementing Good Modeling Practices

Implementing Static Cache

Controlling Parallelization

Implementing Union Pruning

Using Tools to Check Model Performance

Developing a Data Management Architecture

Working with Modeling Content in a Project

Creating and Managing Projects

Enabling Access to External Data

Working with GIT Within the SAP Web IDE

Migrating Modeling Content

Understanding Roles and Privileges

Defining Analytic Privileges

Defining Roles

Masking Sensitive Data

Anonymizing Data