Skip to Content

Create a Calculation View of Type Cube in the SAP HANA Cloud

Use SAP Business Application Studio to create a calculation view.
You will learn
  • How to create a calculation view in SAP Business Application Studio
  • How to join data from another calculation view
jung-thomasThomas JungFebruary 14, 2021
Created by
jung-thomas
January 8, 2021
Contributors
jung-thomas

Prerequisites

A video version of this tutorial is also available:

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

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

      New calculation view
  • Step 2
    1. Drop a join node into the modeling space

      New calculation view
    2. Use the

      plus sign
      sign to add the calculation view to the node.

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

      New calculation view
    4. Click on the

      plus sign
      sign again and add the table PERFORMANCE. Click Finish and you should see both artifacts in the join node:

      New calculation view
  • Step 3
    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
    3. Set the cardinality to 1..1

      New calculation view
    4. In the Mapping tab, add all the columns as output columns. Make sure ID is only added once

      New calculation view
    5. Connect the join node with the aggregation node using the

      arrow

      New calculation view
  • Step 4
    1. Click on the Aggregation node and double-click on the join parent to add all the columns to the output

      New calculation view
    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
  • Step 5
    1. Save and Deploy

      New calculation view
    2. Open the HDI Container in the Database Explorer

      New calculation view
    3. Under Column Views you will find your Calculation View. Choose Open Data

      New calculation view
    4. Go into the Analysis tab. Drag the T-LEVEL attribute into the label axis and the Evaluation Rating into the values axis.

    Which tier level has the highest average evaluation rate?

Back to top