How To Calculate Student Average Marks in SAP HANA Studio Using Calculation View

Scenario : In This Scenario I am going Explaining about Calculating Student Average Marks using Calculated Column in Calculation View.

Calculation Views are used to combine other Analytic, Attribute and other Calculation views and base column tables. These are used to perform complex calculations, which are not possible with other type of Views.

Step 1: Create a Table “STUDENT_DETAILS” with following structure

Execute the table

Open the SQL console and insert the following data

Executed it and see the table data

Step 2 : Create the Calculation View

Go to Schema–>select New–>select Calculation View

Create the Calculation View with the name of “STUDENT_AVERAGE_CALCULATION”.

Select “Finish” Button Then appear the next screen.

Here take one Projection_1

Here select the “+” Symbol to select the Table “STUDENT_DETAILS”

Select the Add all to output

Here create the one Calculated Columns

Click on Calculated Columns –> select New

Create Calculated Column Name ” AVERAGE_OF_STUDENT”

In  Expression Editor give the Syntax like below to find avarage of  the marks

(Total Marks) / (number of subjects)

(“SUBJECT_1″+”SUBJECT_2″+”SUBJECT_3″+”SUBJECT_4”)/4

Now Calculated Column is created

Add “AVERAGE_OF_STUDENT” calculated column to output

Save and Activate the view.

And see the Data Preview.

OUTPUT :

In output we can see “AVERAGE_OF_STUDENT” Calculated Column.