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:

• https://www.sap.com/products/data-warehouse-cloud/trial.html
• https://saphanajourney.com/data-warehouse-cloud/trial/

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:

• https://www.sap.com/products/cloud-analytics/trial.html

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 1.1 - Download BIKE SALES Sample Data
• Exercise 1.2 - Upload BIKE SALES Sample Data
  • Upload CSV Files
• Exercise 1.3 - Upload Currency Conversion Sample Data (TCUR)
  • Data Wrangling

Exercise 2 - Sales Orders

• Exercise 2.1 - Create Business Partners View
  • Dimension View
  • ID + Text Semantic
  • Join Node
  • Projection Node
  • Level Based Hierarchy
  • Data Preview
  • View Deployment
  • Exercise 2.1.1 - Configure Geospatial Data (Latitude, Longitude)
• Exercise 2.2 - Create Products View
  • Exercise 2.2.1 - Create Product Texts View
  • Exercise 2.2.2 - Create Text Association
• Exercise 2.3 - Generate Time Tables and Views
• Exercise 2.4 - Create Sales Orders View
  • Analytical Dataset View
  • Filter Node
  • Associations
  • Measures
  • Replace Table
• Exercise 2.5 - Create Sales Story in SAP Analytics Cloud
  • ID + Description (Text)
  • Level Based Hierarchy
  • Time Series
  • Variance on Previous and Current Period
  • Range Filter
  • Geo Spatial - Bubble Layer

Exercise 3 - Internal Orders

• Exercise 3.1 - Create Employee Data Flow ⭐
  • Data Flow
• Exercise 3.2 - Create Employee View
  • Parent Child Hierarchy (Internal)
• Exercise 3.3 - Create Vendor Product Category Hierarchy View
  • Parent Child Hierarchy (External), Standalone Hierarchy
• Exercise 3.4 - Create Vendor Products View
  • Exercise 3.3.1 - Create Hierarchy Association
    • Hierarchy Association
• Exercise 3.5 - Create Internal Orders View
  • Exercise 3.5.1 - Wrap Currency Tables as Views
  • Exercise 3.5.2 - Apply Currency Conversion ⭐
    • Calculation Node
  • Exercise 3.5.3 - Input Parameters
• Exercise 3.6 - Create My Orders View
  • Exercise 3.6.1 - Create Company Code Data Access Control
    • Data Access Control
  • Exercise 3.6.2 - Use Data Access Control
  • Exercise 3.6.3 - Maintain Data for a Data Access Control
  • Exercise 3.6.4 - SAC Story Filter
• Exercise 3.7 - Create Internal Orders Story in SAP Analytics Cloud ⭐

Exercise 4 - Sales Orders Extension

• Exercise 4.1 - Get data from Open SQL Schema
  • Exercise 4.1.1 - Create Database Access User and Open SQL Schema
    • Database Access User
    • Open SQL Schema
  • Exercise 4.1.2 - Create a local Sales Order Table
    • Database Explorer
  • Exercise 4.1.3 - Adjust the Sales Order View
    • Union Node
  • Exercise 4.1.4 - Use 3rd party database client 🚧🚧🚧
• Exercise 4.2 - Get data from Data Market Place
  • Exercise 4.2.1 - Download Sample Data from the Data Market Place
    • Data Market Place
  • Exercise 4.2.2 - Create Sample Data View
  • Exercise 4.2.3 - Update Sales Orders View with Sample data
• Exercise 4.3 - Get data from Shared Spaces
  • Exercise 4.3.1 - Create Master Data Space
  • Exercise 4.3.2 - Upload Region CSV File
  • Exercise 4.3.3 - Create Sales Organization View
  • Exercise 4.3.4 - Share Sales Organization View
    • Cross Space Sharing
  • Exercise 4.3.5 - Adjust Sales Order View

Exercises in Pipeline

🚧🚧🚧

Lessons: Time Dependency

• Exercise 4.2 - Sharing data between Spaces 🚧🚧🚧
  • Create a Master Data Space
  • Exercise 4.2.2 - Create Cost Center Dataflow
  • Exercise 4.2.3 - Cost Center View
  • Share Cost Center View to other Spaces
• Exercise 4.4 - Pulling data via Connections 🚧🚧🚧
• Exercise - Create Entity Relationship Model (ERM) - 🚧🚧🚧
  • Associations
  • Text Associations
  • Hierarchy Associations
• Create Cost Center Hierarchy View - 🚧🚧🚧
  • Time Dependency 🚧🚧🚧
• [SQL Internal Orders] - 🚧🚧🚧
  • SQL View 🚧🚧🚧
  • Scripted View 🚧🚧🚧
  • Window Functions 🚧🚧🚧
• Excercise 4.5: 🚧🚧🚧
  • Cross Space Sharing 🚧🚧🚧
• Excercise 4.6 View Persistence 🚧🚧🚧

Business Layer 🚧🚧🚧

• [Exercise 7 - Sales Pipeline]
  • [Exercise 7.1 - Create Business Entity]
  • [Exercise 7.2 - Create Consumption Model]
  • [Exercise 7.3 - Create a Cube / Query]
• [Exercise 7 - Sales Quota]
  • [Exercise 7.1 - Create Business Entity]
  • [Exercise 7.2 - Create Consumption Model]
  • [Exercise 7.3 - Create a Cube / Query]
• [Exercise 3 - Second Exercise Description]
  • Exercise 2.1 - Exercise 2 Sub Exercise 1 Description
  • Exercise 2.2 - Exercise 2 Sub Exercise 2 Description

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

• SAP Data Warehouse Cloud
  • SAP Data Warehouse Cloud in SAP Roadmaps
  • Latest and greatest features of SAP Data Warehouse Cloud are presented regularly in What's New
  • SAP Help Site of SAP Data Warehouse Cloud: https://help.sap.com/viewer/product/SAP_DATA_WAREHOUSE_CLOUD/cloud/en-US
• SAP Analyics Cloud
  • SAP Analytics Cloud Getting Started: https://community.sap.com/topics/cloud-analytics/getting-started
  • SAP Analytics Designer Developer Handbook: https://blogs.sap.com/2021/08/25/introduction-to-analytics-designer-developer-handbook/
• SAP Data Intelligence
  • SAP Data Intelligence Tutorials: https://blogs.sap.com/2021/02/04/sap-data-intelligence-hands-on-video-tutorials/

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.