DT187v - Build Analytical Applications with ABAP Cloud

Description

This repository contains the material for the SAP TechEd 2023 session called DT187v - Build Analytical Applications with ABAP Cloud.
Watch the recording of the Jump-Start Session: Build Analytical Applications with ABAP Cloud to get an introduction (slides of the Jump-Start Session).

Overview

This hands-on tutorial introduces attendees to building an analytical data model with ABAP Cloud that can be consumed by analytical applications like e.g., SAP Analytics Cloud. You will learn how to build analytical applications with the ABAP Cloud programming language using ABAP core data services, analytical providers and business services in the ABAP development tools.

Specifically, you will build an analytical application, that uses SAP's Flight Demo Model. You will design the data model and the application in order to analyze the occupation of flights from different perspectives.

While building the data model, you will be introduced to analytical terms like measures, dimensions, cubes and queries as well as to the general idea of analytical data modelling with the star schema.
Previewing the analytical application and exploring its features will deepen this understanding.

Requirements

Experience in ABAP, ABAP CDS and working with the Eclipse based ABAP Development Tools (ADT) is recommended, but not strictly necessary. If you are in a hurry or find it hard to follow the instructions, intermediate and final solutions of the exercises are available ready to be copied & pasted (with low naming adaption effort).

The hard prerequisites to follow the exercises in this repository are that you:

1. get a new trial account for the BTP ABAP environment (please make sure to get a new one if your account is older than 2023-10-15)
2. have the latest version of the ABAP development tools installed
3. have downloaded and installed the templates for analytical CDS views

Exercises

• Prerequisites

  • Get a SAP BTP Trial Account
  • Get the BTP ABAP Environment Trial
  • Install Analytical CDS Templates

• Exercise 1 - Introduction to Analytics in ABAP Cloud

  • Exercise 1.1 - Read: Scope of the Tutorial
  • Exercise 1.2 - Read: Embedded Analytics in ABAP Cloud
  • Exercise 1.3 - Hands-On: Use the FLIGHT Data Model for Analytics
  • Exercise 1 - Summary

• Exercise 2 - Build a Cube with Dimensions

  • Exercise 2.1 - Build the basic Cube
  • Exercise 2.2 - Prepare the Measures
  • Exercise 2.3 - Prepare the Dimensions
  • Exercise 2.4 - Use the Dimensions
  • Exercise 2.5 - Optional - Add and use additional Dimensions
  • Exercise 2 - Summary

• Exercise 3 - Build the analytical Query

  • Exercise 3.1 - Build the initial query
  • Exercise 3.2 - Prepare the Measures
  • Exercise 3.3 - Working Multi-Dimensional
  • Exercise 3 - Summary

IMPORTANT

Contributing

Please read the CONTRIBUTING.md to understand the contribution guidelines.

Code of Conduct

Please read the SAP Open Source Code of Conduct.

How to obtain support

Support for the content in this repository is available during the respective Jump-Start Session: Build Analytical Applications with ABAP Cloud at Friday, November 3, 2023, 7pm CET, for which this content has been designed.
Otherwise, you may request support via the Issues tab.
A SAP Help page for Embedded Analytics in ABAP Cloud is available as well.

License

Copyright (c) 2023 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.