SAP HANA parameters

SAP HANA parameters are used to collect input from the user and return dynamic data based on that input.

Prompting for SAP HANA parameters in Spotfire

If parameters have been defined in SAP HANA, you can configure prompts to have the user give input values for the parameter when they open the connection. The prompts are shown each time the analysis using this data connection is opened. This way, all end users of the analysis can select only the data of their interest when opening the analysis.

When you select data in the Views in Connection dialog, any parameters that have been defined for a table in SAP Hana are listed. You can decide whether to prompt the end user for input values. You can also configure the data connection to fetch input for the parameters using on-demand loading.
To configure prompts for the SAP HANA parameters in the selected view, click Define Prompting.

Note: You cannot change the order of the prompts for SAP HANA parameters. However, you can change the order of other prompts that you have defined in Spotfire.

When you open your connection, you must provide values for the defined prompts. If any default values exist for the SAP HANA parameters, they will be preselected in the Open connection dialog.

SAP HANA parameter types and Spotfire prompt types

Spotfire supports several types of prompts, but depending on the type of SAP HANA parameter, you might only be able to select certain prompt types.

For SAP HANA parameters that are mandatory, prompts are automatically defined in Spotfire. The prompt type is based on the SAP HANA parameter type.

The table lists how parameter types in SAP HANA are mapped to prompt types in Spotfire.


SAP HANA variable type	Spotfire prompt type
Single Value	Manual input or Single selection
Single Value + Multiple values	Manual input, Single selection, or Multiple selection
Interval	Range
Range	(Range)

Note: It is not supported to configure a connection with multiple range prompts.

Variables in SAP HANA are bound to columns and used to filter the values in that column.

Range values in SAP HANA are used to find values larger than or smaller than a certain number. For example, Quantity < 4. This is not directly supported in Spotfire, because in Spotfire, you cannot choose any operators in a range. Instead, ranges are handled as SAP HANA intervals, and to select all values lower than a specific value you would have to specify a really low start value instead.