Skip to content
This repository has been archived by the owner on Feb 2, 2024. It is now read-only.

This repository aims to onboard new users into Modeling in SAP Data Warehouse Cloud in the most practical manner. For that you will build a real working data model, which will embrace specific features and functions.

License

Notifications You must be signed in to change notification settings

SAP-archive/data-warehouse-cloud-modeling

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Important Notice

This public repository is read-only and no longer maintained. For the latest sample code repositories, visit the SAP Samples organization.

Modeling in SAP Data Warehouse Cloud

Description

This repository aims to onboard new users into Modeling in SAP Data Warehouse Cloud in the most practical manner. For that you will build a real working data model, which will embrace specific features and functions. During the journey there will be additional tips and explanations on various modeling concepts.

Overview

"Learning by Doing" is the main principle of this tutorial. Discover and understand the features and modeling concepts by putting your hands on the SAP Data Warehouse Cloud application and build a fully functioning data model yourself.

The exercises are meant to be built in this particular order starting from basic concepts and diving step by step into deeper advanced features while progressing with the exercises. The exercises are also based on each other. Hence, they prerequisite each other.

The tutorial comes along with a sample dataset (CSV files), so that only a minimalistic system setup is required, without any complex source system connection and data ingestion processing activities (Off course, it is still highly recommended to get yourself familiar with those features, especially when you run SAP Data Warehouse Cloud in a full enterprise and productive manner). For this tutorial working with the prepared sample datasets serves the purpose.

In general, you should be aware that SAP Data Warehouse constantly updates and delivers new features. That means, that some of the described features might be outdated and look differently than from your latest version (for that please check regularly the "What's New" website and the SAP Roadmaps in the links section below).

That being said, I hope this tutorial will give you a solid understanding and insights into the fundamental modeling principles of SAP Data Warehouse Cloud on which you can build upon in the future.

And now enjoy the tutorial ;)

San Tran
Product Manager, SAP

p.s. many thanks to Amogh Kulkarni who provided the sample datasets for the exercises.

Pre-requisites

SAP Data Warehouse Cloud

Before you can start with the exercises, please make sure to get a running SAP Data Warehouse Cloud tenant with the latest updates. For that you can apply for a 30-Days free Trial Tenant under the following link:

Please note that the trial version does not provide all available features. Especially the more advanced exercises (e.g. Dataflow) can only be applied with full SAP DWC licence only. For more detailed information about the trial limiation and restriction, please refer to SAP note 3007887.

SAP Analytics Cloud

Optionally you will need also a running SAP Analytics Cloud (SAC), which is required to build the Stories, Dashboards and Visualization on top of the SAP Data Warehouse Models. In case you are not interested, you can skip the exercises with the SAC part. However, it is highly recommended to walk through these exercises as well, to see how the individual features are consumed from the client side. For that, you can request an SAC trial tenant from the following link:

Furthermore, I would like to refer to SAP Analytics Designer Developer Handbook inluding lots of Best Practices: https://blogs.sap.com/2021/08/25/introduction-to-analytics-designer-developer-handbook/

Table of Content

Exercise 1 - Upload Sample Data

Exercise 2 - Sales Orders

Exercise 3 - Internal Orders

Exercise 4 - Sales Orders Extension

Exercises in Pipeline

🚧🚧🚧

Lessons: Time Dependency

Business Layer 🚧🚧🚧

SAP Data Warehouse Fundamentals

  • [Repository Explorer] - 🚧🚧🚧
  • [Data Source Browser] - 🚧🚧🚧
  • [Space Management] - 🚧🚧🚧
  • Time Tables and Views Configurator
  • [Currency Conversion Configurator] - 🚧🚧🚧
  • [Fiscal Calendar Configurator] - 🚧🚧🚧
  • [Modeling Entities] - 🚧🚧🚧
  • [Data Lineage] - 🚧🚧🚧
  • Versioning - 🚧🚧🚧
  • Change Management - 🚧🚧🚧
  • View Persistence - 🚧🚧🚧

How to obtain support

Create an issue in this repository if you find a bug or have questions about the content. For additional support, ask a question in SAP Community.

Links

License

Copyright (c) 2021 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.

REUSE status

visitor badge

About

This repository aims to onboard new users into Modeling in SAP Data Warehouse Cloud in the most practical manner. For that you will build a real working data model, which will embrace specific features and functions.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published