Category: HANA
How-To use data from a dynamic SQL in a procedure
If you are using in your procedure a data load from the HANA model you may need to parametrize for example the Placeholders. I’m not aware about any possibility how […]
How-To Create a temporary local table in a procedure
The temporary tables can be created at runtime and can be used for the same operations as the normal tables. But, based on the table types, the scope is limited. […]
SAP® HANA Analysis Tool (HAT) – Hierarchy
SAP® HANA Analysis Tool Hierarchy is a special form of hierarchy implementation that uses mathematical sets to provide results fast and with fewer queries, comparing to standard hierarchy recursive implementation. […]
SAP® HANA Information Model XML Definition
Every active SAP® HANA Information Model (Attribute views, Analytic views, Calculation views) is saved in the standard table: _SYS_REPO.ACTIVE_OBJECT, in the form of XML code. The columns of the table […]
How-To SAP® HANA Procedures
Find Procedure To find procedure, standard HANA table: “SYS”.”PROCEDURES”, can be used. For example: Searching for Procedure, which contains specific code, the definition column can be used: select * from […]
SAP® HANA Authorization
Please consider, everything written below are mainly my personal experiences and opinions and I may be wrong or inaccurate. Please leave a comment if you find a mistake. Thank you! […]
How-To get metadata of HANA tables
Relevant useful links Selection example with CDATA search API to get the Metadata of the HANA view Columns for a specific table or model SELECT SCHEMA_NAME, TABLE_NAME, COLUMN_NAME, POSITION […]