HA300 - SAP HANA 2.0 SPS07 Modeling Training in Netherlands

  • Learn via: Classroom
  • Duration: 5 Days
  • Price: Please contact for booking options


Course based on software release:
  • SAP HANA 2.0 SPS07
Read more +
We can host this training at your preferred location.

Prerequisites

Essential

  • HA100 SAP HANA - 360° Introduction

Recommended

  • HA150 SAP HANA 2.0 SPS07 - SQLScript for SAP HANA
Read more +

Who Should Attend

  • Application Consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application Developer
  • BI specialist
Read more +

What You Will Learn

  • 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
Read more +

Outline

  • 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
Read more +


Contact us for more detail about our trainings and for all other enquiries!

Avaible Training Dates

Join our public courses in our Netherlands facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

01 juni 2025 (5 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
26 juni 2025 (5 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
25 juli 2025 (5 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
08 augustus 2025 (5 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
09 augustus 2025 (5 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
08 september 2025 (5 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
20 september 2025 (5 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
07 oktober 2025 (5 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
HA300 - SAP HANA 2.0 SPS07 Modeling Training Course in Netherlands

The Netherlands, which is also informally known as Holland, is a country located in Northwestern Europe with overseas territories in the Caribbean. The four largest cities are Amsterdam, Rotterdam, The Hague and Utrecht. Amsterdam is the country's most populous city and the nominal capital, while The Hague holds the seat of the States General, Cabinet and Supreme Court. Rotterdam is the second largest city and has the largest port in Europe. The importance of the Netherlands for Europe is so huge that it cannot be ignored. The country is a founding member of the European Union, Eurozone, G10, NATO, OECD, and WTO.

The tourist attractions of the Netherlands are windmills, canals, and tulips. Canals are an important part of Amsterdam's cityscape and Keukenhof, the Garden of Europe, is the largest public garden in the world. The National Museum Rijksmuseum and the Anne Frank House are must-see places in the Netherlands.

Enhance your IT skills with our comprehensive array of courses, spanning programming, software development, data science, and project management. Benefit from the convenience of choosing your preferred location in Netherlands as our experienced instructors deliver interactive training and real-world insights.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.