Step 1: Create a new graphical calculation view of DIMENSION Data category and add an aggregation node to the view. Let us now try to get maximum salary in each of the employee_category/type using graphical calculation view. Keeping it simple to make the understanding better.Ībove table gives the salary details of each employee type on date basis. Let us understand how it is achieved by considering a simple example.Ĭonsider a simple SALARY_ANALYSIS table as shown below.

'KEEP FLAG' for attributes in Aggregation NodeĪbove property gives chance for end user to leverage the full capacity of calculation engine by utilizing the nature of Aggregation node. So as to reveal out the effectiveness in handling the properties to manage the execution flow.įirst among the property set under discussion is

This Document helps in understanding the nature of execution management by HANA Graphical Calculation Views by utilizing the allowed set of properties in it. One among them is 'Graphical Calculation View', which helps in leveraging the fullest potential of SAP HANA in data modeling sector. For more information, click here.SAP HANA, An appliance with set of unique capabilities has provided wide range of possibilities for end user to perform data modeling. I understand that these countries may not have the same data protection laws as the country from which I provide my personal information. In particular, I consent to the transfer of my personal information to other countries, including the United States, for the purpose of hosting and processing the information as set forth in the Privacy Statement. I agree to the Privacy Statement and to the handling of my personal information. By submitting this form, you confirm that you agree to the storing and processing of your personal data by Salesforce as described in the Privacy Statement. By submitting this form, you acknowledge and agree that your personal data may be transferred to, stored, and processed on servers located outside of the People's Republic of China and that your personal data will be processed by Salesforce in accordance with the Privacy Statement. Reference Materials Toggle sub-navigationīy registering, you confirm that you agree to the processing of your personal data by Salesforce as described in the Privacy Statement.Teams and Organizations Toggle sub-navigation.

Connect to hana from tableau on mac