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

Requires Customer/Partner License

Beginner

10 min.

Use SAP Web IDE Full Stack to create a calculation view to expose to SAP Analytics Cloud

You will learn

Thomas JungOctober 11, 2021

Created byMay 23, 2019

Contributors

This tutorial is designed for SAP HANA service for SAP Business Technology Platform. Consider newer tutorials designed for SAP HANA Cloud.
You have created an anonymized view as explained in this tutorial
You have created and loaded data in the PERFORMANCE table as explained in this tutorial

This tutorial cannot be completed with a trial account.

This calculation view will be consumed in a report in SAP Analytics Cloud

Step 1
In the models folder, create a calculation view called PERFORMANCE_SALARIES
Step 2
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:
Step 3
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
Step 4
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
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.
Which tier level has the lowest average evaluation rate?
T2
T4
T5