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?
-