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:
* 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.
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