- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- 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
- Merging 2 tables with similar column name SAP HANA database
- Using database view in SAP HANA
- Using Attribute view in SAP HANA
- Using Analytic View in SAP HANA
- Using Text join in SAP HANA Modeling
- Creating Index in Column based tables in SAP HANA
- Example of using Text join in SAP HANA

Advertisements