Using column base tables in SAP HANA Calculation view with Star Join

It does not allow base column tables, Attribute Views or Analytic views to add at data foundation. All Dimension tables must be changed to Dimension Calculation views to use in Star Join. All Fact tables can be added and can use default nodes in Calculation View.

For more details, you can refer our tutorial link −

You have four tables, two Dim tables, and two Fact tables. You have to find list of all employees with their Joining date, Emp Name, empId, Salary and Bonus.

This can be achieved using Calculation view with Star Join. You need to convert column based tables to dim Calculation views.