Analytical Views – Data Foundation and Nodes.

Analytical Views – Characteristics, Facts and Dimension Table Overview.

Attribute Views – Keys Fields Filtering Records and Preview Data.

We have given special attention to:įiltering, Selecting, Decision Making, Types, Attributes and measures

We create Logical Containers to hold our Virtual data in views, may it be Attribute Views, Analytical Views, Calculation View or even creating custom calculated column these takes lot of time to search through, and all of these are covered in a detail and simple way with demos in this course. We have covered all concepts from basics to intermediate to advance in step-by-step, We have covered the details of HANA® Architecture, HANA® Modelling, Procedure, XSJS and XS oData and lot More.Īlso, when it comes to HANA® Modeling. HANA® SQL is one comprehensive course covers all the aspect of HANA® Development to help you when it matter. At the end of the course you will have a strong understanding and practical knowledge about SAP® HANA®.Therefore the SQL-console was a gem I never used. The SQL-console has been widely used for selecting data for quite some time but since SAP has its own development environment I was used to developing with the ABAP-tools like the workbench (SE80). With this tool you can easily create and execute your own openSQL-queries from outside the SAP-environment (eg. Luckily there is an alternative: using the SQL Console in Eclipse… This tool allows you to make a join and quick representation of data in minutes, but is also very, very legacy and does not include certain functions, like advanced joining or sorting upfront. Since I want to limit manual work as much as I can, I therefore use the SAP QuickViewer (transaction SQVI).

However, if the amount of data or total number of tables to join increases, the number of manual steps increases. I export the results from one table and upload them again in the other tables selection screen. Most of the time transaction SE16 works fine for me.

Eclipse neon download for sap hana