Reporting in Datasphere can be greatly enhanced with SQLScript to implement more complex requirements without additional persistence.
Description
In SAP Datasphere, more complex reporting requirements cannot always be modeled purely graphically. That is when SQL or SQLScript comes into play. A solid knowledge of the concepts and syntax of the SQLScript language is essential for efficient and high-performance programming in Datasphere.
Important: This is not a complete Datasphere training - we only show the aspects that can be done with SQLScript. Each participant needs access to their own system. We cannot provide a training system.
Agenda
- About SQLScript:
- What is the SQLScript programming language?
- Why is SAP HANA so fast and what does that have to do with SQLScript?
- Fundamentals of the programming language
- Syntactic basics
- Expressions
- Simple SELECT statements
- Procedures and functions
- Processing of date, time, character strings, amounts and quantities
- Declarative programming
- Anonymous blocks
- Table variables
- System variables
- Architecture overview Datasphere
- SAP HANA
- Data Builder
- Business Builder
- Open SQL schema & HDI container
- Programming in the Data Builder
- SQL and SQLScript views
- The Open SQL schema
- Performance of queries in Datasphere
- Exercise scenarios
- Tools
- SQL console in the Database Explorer
- Datasphere
Prerequisites
Participants should have a basic understanding of databases and reporting. Since this training is put together individually, there are no further fixed prerequisites. We can meet your team wherever it currently stands.
Target group
BI consultants & developers