Create a Calculation View of type Cube in SAP HANA service for SAP BTP
- How to create a calculation view in SAP Web IDE Full Stack
- How to join data from another calculation view
Thomas JungNovember 21, 2022
Prerequisites
- 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
PERFORMANCEtable as explained in this tutorial
This calculation view will be consumed in a report in SAP Analytics Cloud
>**This tutorial cannot be completed with a trial account.**
- Step 1
In the models folder, create a calculation view called
PERFORMANCE_SALARIES
- Step 2
Drop a
joinnode 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 tablePERFORMANCE. 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
IDfield to join the entries inSALARIES_ANONYMIZEDwith the records inPERFORMANCE.
Set the cardinality to
1..1
In the mapping tab, add all the columns as output columns. Make sure
IDis 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_YEARandIDto attributes. Set the aggregation of the remaining measures toAVG
- 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 containerinstead and look for the calculation view underColumn Viewsin the database explorer.Go into the Analysis tab. Drag the
T-LEVELattribute into the label axis and theEvaluation Ratinginto the values axis.Which tier level has the lowest average evaluation rate?