Learn How to Model Data with SAP Data Warehouse Cloud

What is Data Warehouse Cloud?

  • Data integration
  • Data modeling
  • Analytical layer

1) Create your management room

2) Configure the “OData” connection.

4) Modeling your data

  • A filter can be applied to the data exiting an entity to then be signed up with;
  • We can, at any time throughout the data modeling, see which data is being published;
  • Formulas can be applied after each action (uploading of data, connections, etc.). For instance, we will create a column based on 2 metrics of the previous entity;
  • It is possible to pick the Join Type linking entities, there are six possible choices: inner, outer-right, outer-left, crossed, complete, natural;
  • The projection operates after each joint to select the data to upload on each side of the resources of data comprised in that joint.
  • At the last stage, after applying all the preferred settings to ensure that all data is properly submitted, it is possible to preview the data.

4) Exposing Data

Conclusion

Closing Notes

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
ZaranTech

Learn the latest in-demand IT technology skills in SAP, Workday, DevOps, Cloud Computing (AWS, GCP, Azure), Salesforce, Oracle and many more