Preparing the Modeling Environment
Getting Started with SAP Web IDE for SAP HANA
Importing an Existing Project in SAP Web IDE for SAP HANA
Creating Calculation Views
Understanding Basic Concepts and Terminology
Checking the Output of a Calculation View
Creating Dimension Calculation Views
Creating Cube Calculation Views
Creating SQL Access Only Calculation Views
Choosing a Data Source for a Calculation View
Working with Common Features of Calculation Views
Defining the
Top View Node
Working with Common Nodes in Calculation Views
- Using Projection Nodes
- Working with Aggregation Nodes
Joining Data Sources in Calculation Views
- Combining data sources using a join node
- Joining more than two tables in a single join node
- Creating Cube with Star Join Calculation Views
- Configuring non-equi joins
- Preventing incorrect aggregations using a dynamic join
- Filtering on Join Nodes
- Optimizing Joins
Working with Union Nodes in Calculation
Views
- Working with the Union Node
Creating Data Slices
- Implementing Minus and Intersect Nodes
Ranking Data
Implementing Rank Nodes
Embedding Functions in Calculation
Views
- Generating Restricted Columns
- Generating Calculated Columns
- Filtering Data
- Implementing Currency Conversion
Creating Dynamic Calculation Views
Implementing Variables
Defining Value Help Views
Implementing Input Parameters
Mapping Variables and Input Parameters
Implementing Hierarchies in Calculation
Views
- Modeling Hierarchies
- Creating Time-Based Dimension Calculation Views
- Using a Hierarchy for Value Help
Developing Custom Logic using SQL
Introducing SAP HANA SQL Console
Implementing SQL in Calculation Views
Querying a Modeled Hierarchy Using SQL
Working with SQLScript
Creating and Using Functions
Creating and Using Procedures
Applying Best Practices for Modeling
Implementing Recommended Modeling Practices
Implementing Best Practices in Calculation View Nodes
Using Tools to Check Model
Performance
- Validating Calculation Views with Performance Analysis Mode
- Debugging Calculation Views with the Debug Query Mode
- Analyzing executions with the SQL Analyzer
Implementing Features to Improve
Performance
- Implementing Union Pruning
- Controlling Parallelization
- Partitioning Tables
Storing Calculation View Results
- Implementing Static Cache to Improve Performance
- Creating Snapshots
Using Additional Modeling Productivity
Tools
- Developing Calculation views more efficiently
Working with Modeling Content in a
Project
- Working in a Modeling Project
- Explaining the Project Structure
- Building Models
- Managing modeling content
Managing the Lifecycle of a Modeling Project
Creating a Project
Enabling Access to External Data
Using Git to Manage Source Code
Deploying an application
Migrating Modeling Content
Implementing Security in SAP HANA Modeling
Defining Analytic Privileges
Defining Roles
Masking Sensitive Data
Anonymizing Data
