Create a Calculation View of Type Cube in the SAP HANA Cloud
- How to create a calculation view in SAP Business Application Studio
- How to join data from another calculation view
Thomas JungDecember 2, 2022
Prerequisites
- 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.
A video version of this tutorial is also available:
- Step 1
Create a new Calculation View via the SAP HANA: Create SAP HANA Database Artifact command pallet entry.
Create a calculation view called
PERFORMANCE_SALARIESof Data Category CUBE. Press Create
- Step 2
Drop a
joinnode 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 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 inV_SALARIESwith 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
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-LEVELattribute into the label axis and theEvaluation Ratinginto the values axis.
Which tier level has the highest average evaluation rate?