Skip to Content

Create a Calculation View of type Cube in the SAP HANA Service

test
0 %
Create a Calculation View of type Cube in the SAP HANA Service
Details
// Explore More Tutorials

Create a Calculation View of type Cube in the SAP HANA Service

Requires Customer/Partner License

05/23/2019

Use SAP Web IDE Fullstack 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

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

Prerequisites

Back to top