Now OnDemand
As organizations expand their use of SAP Datasphere, understanding how to build flexible, high-performing SQL Views becomes essential.
While graphical modeling offers simplicity, SQL scripting unlocks deeper control — enabling advanced joins, parameterization, embedded business logic, and performance optimization directly within the data layer.
In this technical session, we’ll walk step-by-step through building a SQL View using SQL Script in SAP Datasphere and demonstrate how it integrates into the broader semantic and analytical modeling framework.
What You’ll Learn
Create a SQL View Using SQL Script
- Build a SQL View using the SQL Editor
- Select from source tables
- Apply joins and filters
- Add calculated columns
- Preview and validate data output
Use Input Parameters
- Define input parameters within SQL Script
- Create dynamic, reusable views
- Improve flexibility for reporting and modeling scenarios
Implement Business Logic with SQL Functions
- Use CASE statements
- Apply aggregations (SUM, COUNT)
- Introduce window functions
- Embed transformation logic directly into SQL
Performance & Data Layer Integration
- How SQL Views integrate into the Semantic Model layer
- Reuse within Analytical Models
- Key performance considerations when scripting views
Who Should Attend
- SAP Datasphere developers
- Data modelers
- Analytics architects
- Technical consultants
- Anyone looking to extend beyond graphical modeling
If you’re building scalable data models inside SAP Datasphere, this session will provide practical techniques you can immediately apply.will equip you with practical strategies to safeguard your analytics ecosystem while maintaining innovation and speed.
👉 Register now to secure your seat.
Watch OnDemand Now!
Originally Aired: March 19, 2026, 11AM CST
Duration: 30 Min
Register with your business email address to avoid issues when hogging into the event platform
Please see which webinars you have missed on our OnDemand Channel