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

Latest commit

 

History

History
65 lines (43 loc) · 2.98 KB

README.md

File metadata and controls

65 lines (43 loc) · 2.98 KB

Exercise 05 - Importing Tables

📝 Note: This is part of the Fast Track and a mandatory exercise.

💥 Important: 💥
This exercise is only required in case you did not create the tables in Exercise 03 - Prepare Your Data (optional) and the Entity Relationship Model for our sample model manually in Exercise 04 - Creating the Entity Relationship Model (optional) and prefer to import them.

The file for this exercise is “Sales_ER_Model.json” and the file is part of the ZIP file you downloaded.

We will now import the table definitions in form of JSON file by importing a Entity Relationship Model.

  1. Log On to your SAP Data Warehouse Cloud tenant.

  2. Select the menu option Data Builder on the left-hand side.

  3. Select the option New Entity – Relationship Model.

  4. In the New Entity Relationship Model, navigate to the toolbar.

  5. Navigate to the Edit menu.

  6. Open the Import option.

  7. Select the option Import from CSN File.

  8. Select the file “Sales_ER_Model.json”

  9. Click Next.

  10. Select all tables.

  11. Click Import CSN File.


  1. You will receive a message about the import being completed and the tables will be shown on the canvas in form of the imported Entity Relationship Model.

  2. Save the changes to your Entity Relationship model using the Save option in the General menu.

  3. Enter the following details:

    • Business Name - Sales Model - Entity Relationship Model
    • Technical Name - Sales_ER_Model


  1. Click Save.

  2. On the left hand side in the Repository panel, open the list of Views

  3. Now drag the View Time Dimension – Day to the canvas.

  4. Select the table Sales Transactions on the canvas.

  5. Select the arrow and drag and drop the arrow to the view Time Dimension - Day to create a new Association between the table Sales Transactions and the view Time Dimension - Day.

  6. In the panel on the right-hand side now, create a join between the Transaction Date column and the Date column.

  7. You can use the option to arrange all tables in the toolbar.

  8. Your Entity Relationship Model should look like the image shown below

  9. Save the changes to your Entity Relationship model by using the Save option in the General menu.

  10. Deploy the model using the Deploy option in the menu bar.

Summary

As part of the deployment of the Entity Relationship Model, also the underlying tables are being imported and deployed. When you navigate to the Data Builder screen, you should now see a set of 4 tables (3 dimensions and 1 relational dataset) and 1 Entity Relationship Model.

Continue to - Exercise 06: Uploading Data (part of Fast Track and a mandatory exercise)