Skip to Content
Technical Articles
Author's profile photo San Tran

Modeling in SAP Data Warehouse Cloud

I have recently started a tutorial on github, which I use frequently as a resource on various customer and partner workshops.

https://github.com/SAP-samples/data-warehouse-cloud-modeling

“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 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.

I will try to update the content as often as time allows 😉

San

p.s. here is a preview of the table of content:

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Deniz Osoy
      Deniz Osoy

      Very helpful! Thank you for your commitment San!

      Author's profile photo San Tran
      San Tran
      Blog Post Author

      Hi Deniz, always happy to support. Please let me know, if there are any topics you are interested in particular, which I should involve in the tutorial 😉

      Regards,

      San

      Author's profile photo Frank Li
      Frank Li

      Hi Tran,

      Good to start to learn DWC, thank you for your effort.

      Best regards,

      Frank

      Author's profile photo San Tran
      San Tran
      Blog Post Author

      Hi Frank, you're welcome. Please let me know, if you have special modeling feature, which should be integrated into the tutorial.

      Best regards,

      San

       

      Author's profile photo David Pallares Pontnou
      David Pallares Pontnou

      Hello San,

      I’m doing your tutorial –thanks a million for that! 😊– with a trial version of DWC. I’m not able to see the dataflow option anywhere, neither in the Repository Explorer nor in the Data Integration Monitor.

      Please, do you know the reason? Maybe is about the trial version?

      Thanks in advance!

      David

      Author's profile photo Peter Baumann
      Peter Baumann

      Hi David!

      you are right, it is about the trial. You can find a list of restrictions here in the SAP Note: 3007887 - Unsupported Features with SAP Data Warehouse Cloud Trial version

      Current list of restrictions is:

      • SAP Data Wahreouse Cloud, SAP BW Bridge
      • Data Flow and Scheduling functions
      • Mapping of you HDI Container to the SAP Data Warehouse Cloud Space
      • Enablement of APL and PAL in DWC
      • Enablement of Data Lake
      • Creation of Customer Roles
      Author's profile photo David Pallares Pontnou
      David Pallares Pontnou

      Hello Peter,

      Thanks a lot for your reply. Unfortunately, I don’t have access to SAP notes at this moment, but your answer makes it crystal clear anyway.

      Best regards,

      David