Skip to Content

Create a Calculation View of type Cube in SAP HANA service for SAP BTP

test
0 %
Create a Calculation View of type Cube in SAP HANA service for SAP BTP
Details

Create a Calculation View of type Cube in SAP HANA service for SAP BTP

Requires Customer/Partner License
October 11, 2021
Created by
May 23, 2019
Use SAP Web IDE Full Stack to create a calculation view to expose to SAP Analytics Cloud

You will learn

  • How to create a calculation view in SAP Web IDE Full Stack
  • How to join data from another calculation view
QR code

Prerequisites

  • This tutorial is designed for SAP HANA service for SAP Business Technology Platform. Consider newer tutorials designed for SAP HANA Cloud.
  • You have created an anonymized view as explained in this tutorial
  • You have created and loaded data in the PERFORMANCE table as explained in this tutorial

This tutorial cannot be completed with a trial account.

This calculation view will be consumed in a report in SAP Analytics Cloud


Step 1: Create a Calculation View

In the models folder, create a calculation view called PERFORMANCE_SALARIES

New calculation view
Log on to answer question
Step 2: Join the calculation view and the table

Drop a join node into the modelling space

New calculation view

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

New calculation view

Type in the name of the calculation view. Select if and click Finish

New calculation view

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

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

Drag and drop the ID field to join the entries in SALARIES_ANONYMIZED with the records in PERFORMANCE.

New calculation view

Set the cardinality to 1..1

New calculation view

In the mapping tab, add all the columns as output columns. Make sure ID is only added once

New calculation view

Connect the join node with the aggregation node using the arrow

New calculation view
Log on to answer question
Step 4: Configure semantics

Click on the aggregation node and double-click on the join parent to add all the columns to the output

New calculation view

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

Right-click on the calculation view and select Build selected files

New calculation view

Once the build is successful, right-click on the view and select Data preview

If you get an error, choose Open HDI container instead and look for the calculation view under Column Views in the database explorer.

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 lowest average evaluation rate?
×

Next Steps

Back to top