Skip to Content

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

Requires Customer/Partner License
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
jung-thomasThomas JungOctober 11, 2021
Created by
Lsubatin
May 23, 2019
Contributors
jung-thomas
Lsubatin

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

    In the models folder, create a calculation view called PERFORMANCE_SALARIES

    New calculation view
  • Step 2

    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
  • Step 3

    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
  • Step 4

    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
  • Step 5

    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?

Back to top