You are prompted to enter a value for an SAP HANA variable or a string
input parameter when acquiring an analytic view in Download from SAP HANA
One mode and when creating a document on an analytic view in
Connect to SAP HANA One mode.
Each SAP HANA variable defines a filter on a dimension of a view. You enter a
value for each dimension before data is acquired, and the value appears as a facet
row after acquisition.
You enter a value for each SAP HANA input parameter when acquiring data, and
SAP Lumira passes the value to a calculation, such as a formula
for a calculated measure. When entering a value for a string input parameter, you
must enter an SQL statement, using single quotes to indicate the beginning and end
of the statement string. For example, enter BUKRS='CALP' to
search for CALP.
- Connect to an SAP HANA instance in Download from SAP HANA
One or Connect to SAP HANA One mode.
- Choose which data to acquire:
A HANA Variables box appears, listing the variables and input
parameters defined for the analytic view. Variables are prefixed by "VAR" and
input parameters are prefixed by "IP."
- Choose a variable or an input parameter.
The dimension or input parameter value appears in the right pane.
- Choose one or more values, and select Add.
To choose multiple individual values, press and hold Ctrl and select each
value. To choose a range of values, press and hold Shift and select
the first and last value in the range.
The selected values appear in the bottom pane.
- Select OK.
- If you are acquiring data through Preview and select data, select
Create to start the data acquisition.
Data appears in the Prepare room, and each
variable appears as a facet with the selected prompt values.
The Variables button appears at the top of the facets pane. Select
the button to view the values you chose for SAP HANA variables.