---
parser: v2
auto_validation: true
time: 10
author_name: Thomas Jung
author_profile: https://github.com/jung-thomas
tags: [ tutorial>beginner, products>sap-hana, products>sap-hana-cloud, products>sap-business-application-studio]
primary_tag: products>sap-hana
slug: hana-cloud-create-cube-calculation-view
canonical_url: https://developers.sap.com/tutorials/hana-cloud-create-cube-calculation-view
---

# Create a Calculation View of Type Cube in the SAP HANA Cloud
<!-- description --> Use SAP Business Application Studio to create a calculation view.

## Prerequisites

- You have created an anonymized view as explained [in this tutorial](hana-cloud-calculation-view-differential-privacy).
- You have created and loaded data in the `PERFORMANCE` table as explained [in this tutorial](hana-cloud-create-db-project).

## You will learn

- How to create a calculation view in SAP Business Application Studio
- How to join data from another calculation view

## Intro

A video version of this tutorial is also available:

<iframe width="560" height="315" src="https://www.youtube.com/embed/fwwPcYZb-jQ" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

---

### Create a Calculation View

1. Create a new **Calculation View** via the **SAP HANA: Create SAP HANA Database Artifact** command pallet entry.

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/1_0.png)

2. Create a calculation view called `PERFORMANCE_SALARIES` of Data Category **CUBE**. Press **Create**

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/2.png)

### Join the calculation view and the table

1. Drop a `join` node into the modeling space

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/3.png)

2. Use the ![plus sign](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/plus.png) sign to add the calculation view to the node.

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/4.png)

3. Type in the name of the anonymized view from the previous tutorial - `V_SALARIES`. Select it and click **Finish**

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/5.png)

4. Click on the ![plus sign](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/plus.png) sign again and add the table `PERFORMANCE`.  Click **Finish** and you should see both artifacts in the join node:

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/6.png)

### Configure the join

1. Double-click on the join node. A panel will open on the right.

2. Drag and drop the `ID` field to join the entries in `V_SALARIES` with the records in `PERFORMANCE`.

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/7.png)

3. Set the cardinality to `1..1`

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/8.png)

4. In the **Mapping** tab, add all the columns as output columns. Make sure `ID` is only added once

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/9.png)

5. Connect the join node with the aggregation node using the ![arrow](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/arrow.png)

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/1.gif)

### Configure semantics

1. Click on the **Aggregation** node and double-click on the join parent to add all the columns to the output

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/10.png)

2. Go into the **Semantics** node and change the `START_YEAR` and `ID` to attributes. Set the aggregation of the remaining measures to `AVG`

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/11.png)

### Build and test

1. **Deploy**

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/13.png)

2. Open the HDI Container in the Database Explorer

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/14.png)

3. Under **Column Views** you will find your Calculation View.  Choose **Open Data**

    ![New calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-create-cube-calculation-view/15.png)

4. Go into the **Analysis** tab. Drag the `T-LEVEL` attribute into the label axis and the `Evaluation Rating` into the values axis.

---