SAP HANA View Extract

This extract retrieves data from SAP HANA Calculation Views for further processing in Jedox.

Connection Only SAP HANA connections are allowed. The connection must be established before creating the extract.
Schema The schemas from the connection are listed here. Only schemas that the user has access to are visible.
Table SAP HANA calculation view qualified name, based on the connection and schema selected.
View Columns Displays View dimension columns, based on the selected source database.
View Measures Displays View measures for the columns in the View.

Possible aggregations are:

  • SUM: gets the sum of the selected column (from all result rows)
  • MIN: gets the minimum value of the selected column
  • MAX: gets the maximum value of the selected column
  • AVG: gets the average value of the selected column (from all result rows).
  • COUNT: counts occurrences of selected columns (of all result rows)
  • SUM_DISTINCT: same as SUM, but applied to distinct values*
  • AVG_DISTINCT: same as AVG, but applied to distinct values*
  • COUNT_DISTINCT: same as COUNT, but applied to distinct values*

* duplicated result rows are not calculated

variables Contains values for SAP HANA Calculation View variables and input parameters that will be used for the query in SAP HANA.

The variables (and input parameters) have to be defined beforehand in the Calculation View. If the variable definition allows it, multiple values can be set.

  • For input parameters, only the "Equals" operator is supported.
  • For variables, all operators are supported.

variable and input parameter default values will be used, unless other values are specified by the user. variables and input parameters that are defined as mandatory must have a non-empty value set, provided they do not have a default value defined. If this is not the case, an error message will appear.

Details on variables used in the extract can be viewed by right-clicking on the variable or clicking on the cog wheel in the variables table.

Sorting Ascending or descending order of the entered column.

Updated September 27, 2024