SAP Query

To create a new data set from an existing SAP connection, follow the steps below:

  1. If you have not yet configured the database connection, see SAP. Then proceed with the steps below.

    If you see the ‘Create Visualization’ dialog box, press the ‘Close’ button close to continue with the steps below (recommended).

    200

    You can also press Create a Query to open the ‘New Data Worksheet’ dialog box, where you can select the query you wish to create. This allows you to skip the ‘Add’ button new objects and proceed to the next steps.

  2. Open the Data Worksheet that will contain the data. (See Create a Data Worksheet or Edit a Data Worksheet.)

  3. Press the ‘Add’ button new objects, and select ‘SAP Query’ tabular subquery appropriate for the data connection you previously created, either ‘SAP ABAP Query’, ‘SAP BAPI Query’, or ‘SAP Table Query’. This opens the ‘SAP Query’ dialog box.

    dataSourceSAP5

  4. For an SAP ABAP connection, follow the steps below:

    1. Select the desired ‘Infoset’ and ‘User Group’.

    2. Press the Find button. This populates the ‘Query Name’ menu.

    3. Select the desired query in the ‘Query Name’ menu.

    4. Press the Load Parameters button. To supply a value for a parameter, check the corresponding box and enter a parameter value.

    5. Optional: To add additional parameters, press the Add button. To remove a parameter, check the corresponding box and press the Remove button.

      dataSourceSAP7

  5. For an SAP BAPI connection, follow the steps below:

    1. Press the Find button. This populates the ‘Object Type’ menu.

    2. Select the desired ‘Object Type’.

    3. Press the Find button. This populates the ‘Function Name’ menu.

    4. Select the desired function in the ‘Function Name’ menu.

    5. Press the Find button. This populates the ‘Table’ menu.

    6. Select the desired table in the ‘Table’ menu.

    7. Press the Load Parameters button. To supply a value for a parameter, check the corresponding box and enter a parameter value.

    8. Optional: To add additional parameters, press the Add button. To remove a parameter, check the corresponding box and press the Remove button.

      dataSourceSAP8

  6. For an SAP Tables connection, follow the steps below:

    1. Select the desired ‘Type’.

    2. Optional: In the ‘Table Name Contains’ field, enter a table name or name fragment to restrict the tables displayed to those that match the entered text.

    3. Press the Find button. This populates the ‘Table Name’ menu.

      This may take a few minutes.

    4. Select the desired table in the ‘Table Name’ menu.

      dataSourceSAP9

  7. Press OK. This creates a new data block in the Data Worksheet.

  8. Optional: Right-click on the data block, and select ‘Properties’ from the context menu. Note: You can also access menu options from the ‘More’ button (menu horizontal) in the mini-toolbar. This opens the ‘Table Properties’ panel. In the ‘Name’ field, enter a name for the data block, and press ‘OK’. (See Modify a Column for information about how to rename columns.

    Names must be unique without respect to case (e.g., "num1" is the same name as "Num1").

  9. Press the ‘Save’ button save in the toolbar to save the Data Worksheet.

You can now do pipeline operations on this data, as described in Prepare Your Data, or you can proceed to create Dashboards based on this Data Worksheet. See Visualize Your Data for information about how to construct a Dashboard.