Define / Test Query Dialog Box 
This dialog box enables you to test and update the query or query view definition of an SAP BI query data service. You can use this dialog box to enter values for variables or filters, execute the query, and select required output fields that you need in the BI query data service.
You display the dialog box by right-clicking the BI query data service and choosing Define / Test Query from its context menu. The Define / Test Query dialog box is displayed, showing all of the fields that it processes.
Structure
The dialog box is divided as follows:
In the Specify filter section:
The Input group contains the names of all input fields on the Input port of the data service. You may enter input values in the fields to test the query with these filter values.
The Variables group contains the names of all variables on the Variables port of the data service, if any. You may enter variable values in these fields to test the query with these values.
In the Select fields for output port section:
The Select fields for output ports list contains all of the fields at the output from the data service. When you select the checkbox next to a field, it will be included in the query results.
The Select all checkbox at the top right enables you to check all of the fields displayed in the right pane.
The Clear all checkbox removes the checks from all the fields in the right pane.
In the Review output section, the results of the values you have currently selected are displayed in a table after you click the Execute button.
Click Execute to execute the query with the values provided above and display the results in a table in the Review output section.
Click Generate to update the query or query view definition, adding the checked fields to the data service's Output port and removing the unchecked fields.
Click Close to close the dialog box.
CautionBe aware that you actually update the BI query or query view definition with this dialog box.
End of the caution.