sap-training-courses
8411  Reviews star_rate star_rate star_rate star_rate star_half

SAP HANA 2.0 SPS07 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
View Full Schedule Train Your Team
$4,600 USD
Duration 5 days
Course Code HA300-v019
Available Formats Virtual, Classroom

Upcoming Course Dates

  • Dec 8, 2025 - Dec 12, 2025 (5 days)
    Virtual  Location Details | 9:30 AM – 5:30 PM EST
    Language English
    Select from 1 options below
    Virtual |9:30 AM – 5:30 PM EST
    Virtual | 9:30 AM – 5:30 PM EST
    Enroll
    Enroll Add to quote
Ask a Question Request Other Date Request On-site Course

Overview

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 SPS07 - SQLScript for SAP HANA

Course Details

Course Content

  • 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

Course based on software release

  • SAP HANA 2.0 SPS07
Read Less
|
View Full Schedule

Schedule

1 options available

  • Dec 8, 2025 - Dec 12, 2025 (5 days)
    Virtual  Location Details | 9:30 AM – 5:30 PM EST
    Language English
    Select from 1 options below
    Virtual |9:30 AM – 5:30 PM EST
    Virtual | 9:30 AM – 5:30 PM EST
    Enroll
    Enroll Add to quote

FAQ

Does the course schedule include a Lunchbreak?

Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does Ascendient Learning deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth.  We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How do I request a W9 for Ascendient Learning?

View our filing status and how to request a W9.

Reviews

The class was very vast paced however the teacher was very good at checking in on us while giving us time to complete the labs.

The technical data in the AWS Solutions Architect course was very thorough.

Class was very informative, although one lab didnt but will try again later

Very good material, the instructor was clear explaining the topics, and the labs were easy to follow it.

This course gave me a clearer understanding of the AWS cloud architecture.