Skip to Content

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

test
0 %
Create a Calculation View of Type Cube in the SAP HANA Cloud
Details

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

February 14, 2021
Created by
January 8, 2021
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
QR code

Prerequisites

A video version of this tutorial is also available:


Step 1: 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
  2. Create a calculation view called PERFORMANCE_SALARIES of Data Category CUBE. Press Create

    New calculation view
Log on to answer question
Step 2: Join the calculation view and the table
  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
Log on to answer question
Step 3: 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
  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
Log on to answer question
Step 4: 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
  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
Log on to answer question
Step 5: Build and test
  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?
×

Next Steps

Back to top