Specifying values for SAP HANA variables and string input parameters

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.

  1. Connect to an SAP HANA instance in Download from SAP HANA One or Connect to SAP HANA One mode.
  2. Choose which data to acquire:
    • To acquire particular data, select an analytic view, select Preview and select data, select Select, choose the dimension values and measures, and select Edit Variables.

      When no variables or input parameters are defined in a view, the Edit Variables button is not available.

    • To acquire all data available in an analytic view, choose the view, and select Create.
    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."
  3. Choose a variable or an input parameter.
    The dimension or input parameter value appears in the right pane.
  4. 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.
  5. Select OK.
  6. 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.