Hana Studio Tips & Tricks: Lineage

Hana Studio Tips & Tricks: Lineage

SAP HANA
Graphical calculation views can be very complex – when a view consist of many nodes (joins, unions, projections), it is difficult to find what is the source (table, another view) of the field is. When you need to find the original value, which is common during troubleshooting, it is not convenient to click from node to node to find the source table or the source view. In such cases Show Lineage button is helpful. [caption id="attachment_140" align="aligncenter" width="300"] Enable Lineage for HANA Graphical View[/caption] The option is available on semantics (always the last component of calculation view). After activating Show Lineage button, the path for the selected field is marked in orange: Open view semantics. Select the field (line on right side). Click Show Linage. The path is marked like…
Read More
SAP HANA: using SQL for graphical views’ analysis

SAP HANA: using SQL for graphical views’ analysis

SAP HANA
In general, SAP HANA’s objects can be built using two different approaches: SQL language (SQL views, table functions, procedures); Graphical Blocks (graphical calculation views). Usage of graphical calculation views has some advantages (comparing to SQL objects): they are easier to maintain, the flow is more obvious and easy to understand, additionally it’s more convenient to change them and it’s very simple to show data in the intermediate steps (data preview option). On the other hand, using SQL objects gives the ability for an easy extension of the code in the console – you can always take part of SQL code, copy it to the console, modify, run and check the results. Fortunately, the same approach can be used together with graphical view – there is an SQL object behind every…
Read More
SAP HANA – data import from file

SAP HANA – data import from file

SAP HANA
In SAP BW instant data load from Excel or from CSV file is quite tiring, especially when it’s one time load for testing purposes or Proof of Concept. Fortunately in SAP HANA there is easy and convenient way of data import from file. Using Import Data from Local file you can: Import CSV or Excel files; Create new table as a target or use existing one. When you file is ready, to import it to SAP HANA using HANA Studio: 1. Select File – Import – SAP HANA Content – Data from Local File. 2. Choose target system where you would like to import data. 3. Choose source file (from computer). 4. Define file details (field delimiter, header row, start and end line). 5. Select existing target table or create…
Read More
SAP Hana Studio: Data Preview

SAP Hana Studio: Data Preview

SAP HANA
Data Preview functionality allows users to check view results directly in HANA Studio. By default, just after selecting Data Preview – Raw Data, results data are displayed immediately. It can be inconvenient only when you are previewing huge data set or if you would like to filter data before previewing them. The default behavior of Data Preview can be changed in Window – Preferences – SAP HANA – Modeler – Data Preview – Execute the default query on data preview. If Execute the default query on data preview checkbox is not checked, when you select Data Preview – Raw Data, data will not be displayed immediately, but only after selecting Execute button. Before selecting Execute button you can apply filter on your data set, but be careful with Show list…
Read More