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
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
- Step 2
joinnode into the modelling space
Use thesign to add the calculation view to the node.
Type in the name of the calculation view. Select if and click Finish
Click on thesign 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
IDfield to join the entries in
SALARIES_ANONYMIZEDwith the records in
Set the cardinality to
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
IDto attributes. Set the aggregation of the remaining measures to
- 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 under
Column Viewsin the database explorer.
Go into the Analysis tab. Drag the
T-LEVELattribute into the label axis and the
Evaluation Ratinginto the values axis.
Which tier level has the lowest average evaluation rate?