Create a Calculation View of Type Cube in the SAP HANA Cloud

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

Drop a join node into the modeling space

Use the

Type in the name of the anonymized view from the previous tutorial - V_SALARIES. Select it and click Finish

Click on the

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

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

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.