A video version of this tutorial is also available:
Step 1: Create a Calculation View
-
Create a new Calculation View via the SAP HANA: Create SAP HANA Database Artifact command pallet entry.
-
Create a calculation view called PERFORMANCE_SALARIES
of Data Category CUBE. Press Create
Step 2: Join the calculation view and the table
-
Drop a join
node into the modeling space
-
Use the
sign to add the calculation view to the node.
-
Type in the name of the anonymized view from the previous tutorial - V_SALARIES
. Select it and click Finish
-
Click on the
sign again and add the table PERFORMANCE
. Click Finish and you should see both artifacts in the join node:
Step 3: Configure the join
-
Double-click on the join node. A panel will open on the right.
-
Drag and drop the ID
field to join the entries in V_SALARIES
with the records in PERFORMANCE
.
-
Set the cardinality to 1..1
-
In the Mapping tab, add all the columns as output columns. Make sure ID
is only added once
-
Connect the join node with the aggregation node using the 
Step 4: Configure semantics
-
Click on the Aggregation node and double-click on the join parent to add all the columns to the output
-
Go into the Semantics node and change the START_YEAR
and ID
to attributes. Set the aggregation of the remaining measures to AVG
Step 5: Build and test
-
Save and Deploy
-
Open the HDI Container in the Database Explorer
-
Under Column Views you will find your Calculation View. Choose Open Data
-
Go into the Analysis tab. Drag the T-LEVEL
attribute into the label axis and the Evaluation Rating
into the values axis.