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 −

https://www.tutorialspoint.com/sap_hana/sap_hana_calculation_view.htm

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.

SAP Developer

Published on 05-Feb-2018 15:40:22

• Related Questions & Answers
• Advantages of using Calculation View without Star Join
• Using Calculation views inside another calculation view in SAP HANA
• Using different Projection options in Calculation view in SAP HANA
• Consuming Attribute/Analytic view in a Calculation view in SAP HANA
• Different Nodes option in a Calculation view in SAP HANA
• SAP HANA Modeling on top of row and column base tables
• Advantages of using Column based tables in SAP HANA
• Using Text join in SAP HANA
• Using Analytic View in SAP HANA
• Using Attribute view in SAP HANA
• Using database view in SAP HANA
• Merging 2 tables with similar column name SAP HANA database
• Using Text join in SAP HANA Modeling
• Creating Index in Column based tables in SAP HANA
• Join using CE functions in SAP HANA database