Create a Graphical View in SAP Data Warehouse Cloud
- What graphical views are
- How to create a graphical view
- How to rename columns in your graphical view
- How to restore columns in your graphical view
- How to deploy a graphical view
This tutorial is part of a mission, in which you try to help Best Run Bikes to to get a holistic view of their sales data by using the power of SAP Data Warehouse Cloud. You will get the sales data of Best Run Bikes and it is your mission to use the features of SAP Data Warehouse Cloud to help the bike suppliers make the best possible business decisions.
This mission consists of 8 modules that contain the necessary steps you need to follow in your mission to help Best Run Bikes:
- Sign up for trial.
- Get to know the SAP Data Warehouse Cloud interface
- Add users and assign roles
- Create your Space
- Import your datasets
- Create an entity relationship model
- You are here -> Create a graphical view model
- Define measures, business semantics and preview your data
You can also follow the steps in this tutorial by watching this video
- Step 1
In SAP Data Warehouse Cloud, you can use the graphical view builder to easily create data views. This allows you to work intuitively without having to be familiar with SQL statements.
In the graphical view builder, you have many resources to model your data, combine them from many sources and assigning business semantics that make your output easier to understand. Here is an example of a graphical view modelled in SAP Data Warehouse Cloud.
If you are comfortable writing SQL code or want to use SQL Script to create your view, you can use the SQL View editor.
- Step 2
Go to the Data Builder and click on the New Graphical View button.
Now that you are in the graphical model builder, it’s time to find the data. As you imported CSV files, your data is under Repository, on the top right-hand side of the screen.
To start building your model, click and drag the
SalesOrderstable onto the canvas.
As you can see, an output node appears on the canvas as soon as your drop your table in it. The output node is where all of our join table information will appear once you’ve completed the model.
- Click on the output node and then click on the data preview button to see a preview of the sales orders data.
Next, drag the table
SalesOrderItemson top of the
SalesOrderstable to join the two tables. The icon that has appeared is our join node called Join One. The column
SalesOrderIDfrom both tables is automatically joined based on entity-relationship model.
Now drag in the
BusinessPartnerstable. We’ll go ahead and join it to the
SalesOrderstable. The column
Partner IDfrom each table will join automatically, but if you want to double check, look at the join properties panel.
If an alert has popped up on the Join 2 node, click on the join and make sure the
PartnerIDcolumn from both tables is connected.
Next, join the
Addressestable to your
AddressIDwill automatically be mapped based on the association in the entity relationship model.
Now you’ve joined all the tables for this mission.
- Step 3
With the graphical view in place, rename some columns to help others understand better what the data is about. Rename the
Grossamountcolumn from the
SalesOrderstable and from the
SalesOrderItemstable so you can tell them apart.
To do this, click on the projection one node immediately on the right-side of the output node.
Search for the
GrossAmountcolumn in the projection properties panel.
If one of the columns is greyed out, this means the column has been automatically removed. Click on the dots next to it and select Restore column.
Next, click on the column name. On the canvas, you will see a highlight that shows you exactly where the column originates from.
GrossAmountcolumn originating from the
Then rename the
GrossAmountcolumn originating from the
- Step 4
You have successfully created your graphical view. It is now extremely important to first save, and then deploy your view. When you save an object, it is stored in the SAP Data Warehouse Cloud repository, which contains the design-time definitions of all your objects. When you deploy an object, you are creating a run-time version for use in the SAP Data Warehouse Cloud database.
Click on the save icon on the top left and give your graphical view an appropriate name.
Once done, click on the deploy icon next to the save icon to deploy your model.
How can you see a data preview of your created Graphical View?