In this exercise we will build a dimension view with Spatial Reference and associate it with E_mobility-Teched view built in exercise 4.
At the conclusion of this exercise your Graphical View will look similar to the image below
Click on Close button to go back to the DataBuilder
Click on the New Graphical View option in the Data Builder.
To import the data from 'Hana Cloud' navigate to the Sources tab and find the TechEd_HC connection under the Connections. Under TechEd_HC Connection drill down on ANA160
Under ANA160 drill down on Views and select EMOBILITY_LIVE_CHARGE_STATUS(table) Drag and drop the table in to Canvas
(Drill down flow Connections -> TechEd_HC -> ANA160-> Views-> EMOBILITY_LIVE_CHARGE_STATUS)
Click on Import and Deploy
Click on Output View
Change Semantic Usage from "Relational Dataset" to "Dimension".
Click on the "EMOBILITY_LIVE_CHARGE_STATUS" view to open the context menu
Click on 'fx'(Calculated Columns).
Click on the + icon and select Geo-Coordinates Column
Select Latitude as LAT
Select Longitude as LONG
Click on Output View
And change the Business Name as E_mobility_location
Technical Name as Location
Set the Expose for Consumption to 'ON'
Click on Save, again on Save and then Deploy.
See that Dimension View has been Deployed
From the context menu of E_mobility_location select Preview to see the data.
Click on Close button and Go to DataBuilder
Click on the view E_mobility-Teched
Scroll down to add the Associations.
Click on the + icon to select the Association.
Click on Association
Search for View (Dimension) E_mobility_location
Select that View and click on "OK"
See the Mappings between both the Views.
We can see the associations in the E_mobility-Teched view
From the context menu of E_mobility-Teched select Preview data to see the data.
Click on Deploy to update the changes.
Congratulations on completing all SAP DataWarehouse Cloud related exercises.
In the next section we would be consuming the view in SAP Analytics Cloud to analyse and get insights from data.