Create a Calculation View of type Cube in SAP HANA service for SAP BTP

In the models folder, create a calculation view called PERFORMANCE_SALARIES

Drop a join node into the modelling space

Use the sign to add the calculation view to the node.

Type in the name of the calculation view. Select if 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:

Double-click on the join node. A panel will open on the right.

Drag and drop the ID field to join the entries in SALARIES_ANONYMIZED 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

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

Right-click on the calculation view and select Build selected files

Once the build is successful, right-click on the view and select Data preview

If you get an error, choose Open HDI container instead and look for the calculation view under Column Views in the database explorer.

Go into the Analysis tab. Drag the T-LEVEL attribute into the label axis and the Evaluation Rating into the values axis.