📝 Note: This is part of the Fast Track and a mandatory exercise.
In this exercise, we will create the new Dimension View based on our previously created tables. Part of the steps of defining the dimension will also be to configure the geographic enrichment, so that we can visualize the Store Location on a map later in SAP Analytics Cloud.
-
Log On to your SAP Data Warehouse Cloud tenant.
-
Select the menu option Data Builder on the left-hand side.
-
Click New Graphical View.
-
On the left-hand side you can decide between:
- Repository: Here you have access to the local tables (imported data), Views, Intelligent Lookups and Shared Objects.
- Sources: Here you have access to tables and views from your connections.
-
Ensure you select the option Repository.
-
Open the list of Tables.
-
You are presented with the list of tables, which we created previously.
-
Drag and Drop the table Store to the canvas.
-
You automatically will – in addition to the table you dragged to the canvas – receive the output view as well, in our example called View 1
-
Navigate to the Properties window.
-
Here you can configure Properties for the final output of this view:
- You can configure the Business Name as well as the Technical Name.
- You can configure the Type of Dataset.
- You can decide if the View can be consumed or not.
- You can choose which of the available Columns are shown or will be hidden.
- You can define additional Associations.
- You can provide details on the Business Purpose, which then will be available as part of the Business Catalog.
- Enter
- Dimension Store as Business Name.
-
The Technical Name will be generated based on the Business Name, but you can also change it.
-
Set the Semantic Usage to Dimension option.
-
Enable the option Expose for Consumption.
-
Now click on the table Store on the canvas.
-
When you select the table on the canvas, you have the following options (top to bottom)
- You can add Filter on top of the Table.
- You can Rename or Hide columns as part of a Projection.
- You can add Calculated Columns.
- You can add an Aggregation View.
- You can add additional tables / views based on suggested joins, which are based on your Entity Relationship model.
- You can open the table in the editor.
- You can preview the data.
-
Use the option to add a new calculated column. This option also includes the ability to configure the geographic enrichment.
-
Now click on the new entry “fx” on the canvas.
-
Navigate to the properties on the right hand side.
-
Click on the “+” sign and select the option Geo-Coordinates Column.
-
You are presented with the properties for the new column
-
Configure the following details:
- Business Name: Store Location
- Technical Name: Store_Location
- Latitude: Latitude
- Longitude: Longitude
-
After you configured the details, click on the the “<Columns” option in the properties window to go back.
-
Select the final output node for the Dimension View.
-
Navigate to the properties on the right hand side.
-
Navigate to the Attributes area.
-
Use the pencil icon (top right area) to open the details for the Attributes.
-
Ensure the Semantic Type for the line item Store Name is set to Text.
-
Set the Label Column for the line item Store ID to be the Store Name.
-
Click Close.
-
In the toolbar in the General menu, use the option to Save your changes.
-
After saving your dimension View, ensure you deploy the view.
-
In the menu on the left hand side, click on the Home icon.
You've now created your dimension view Dimension Store including the added geo-coordinates column Store location, which is required to use visualizations on maps within SAP Analytics Cloud.
Continue to - Exercise 08: Creating the View (part of Fast Track and a mandatory exercise)