sap-training-courses
7926  Reviews star_rate star_rate star_rate star_rate star_half

SAP HANA 2.0 SPS06 Modeling

Skills Gained This course will prepare you to: -Develop information models following SAP best practices for maximum performance and flexibility -Get started with SQL and SQL-Script based modeling...

Read More
$4,600 USD GSA  $3,930.98
Course Code HA300-v018
Duration 5 days
Available Formats Virtual, Classroom

Skills Gained

  • This course will prepare you to:
       -Develop information models following SAP best practices for maximum performance and flexibility
       -Get started with SQL and SQL-Script based modeling
       -Manage projects and modeling content in the SAP Web IDE for SAP HANA
       -Implement security and data access controls around SAP HANA data models

Who Can Benefit

  • Application Consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application Developer
  • BI specialist

Prerequisites

  • Essential:
       -HA100 SAP HANA - 360° Introduction
  • Recommended:
       -HA150 SAP HANA 2.0 SPS06 - SQLScript for SAP HANA

Course Details

Course Content

  • Calculation Views
       -Introducing Calculation Views
       -Understanding the Different Types of Views
       -Working with Common View Design Features
  • Using Nodes in Calculation Views
       -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
  • Modeling Functions
       -Create Restricted and Calculated Columns
       -Filtering Data
       -Using Variables and Input Parameters
       -Implementing Hierarchies
       -Implement Currency Conversion
       -Defining Time-Based Dimension Calculation Views
  • Using SQL in Models
       -Introducing SAP HANA SQL
       -Query a Modeled Hierarchy Using SQLScript
       -Working with SQLScript
       -Creating and Using Functions
       -Creating and Using Procedures
  • Persistence Layer
       -Defining the Persistence Layer
       -Loading Data into Tables
       -Accessing Remote Data
  • Optimization of Models
       -Implementing Good Modeling Practices
       -Implementing Static Cache
       -Controlling Parallelization
       -Implementing Union Pruning
       -Using Tools to Check Model Performance
       -Developing a Data Management Architecture
  • Management and administration of Models
       -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
  • Security in SAP HANA Modeling
       -Understanding Roles and Privileges
       -Defining Analytic Privileges
       -Defining Roles
       -Masking Sensitive Data
       -Anonymizing Data

Course based on software release

  • SAP HANA 2.0 SPS06
|
View Full Schedule