Adding Prompts to an SAP BW BEx Query Connection
You can define prompting for a data connection to an SAP BW BEx query. Using prompting, you can let the end user define values for BEx variables, upon opening the connection.
About this task
Before you begin
Note: The following example describes the process for adding prompting for a BEx variable in a saved connection in the library. However, you can add prompts to connections embedded in an analysis file too.
Procedure
Parent topic: Prompting for SAP BW BEx Variables
To show prompts when opening an analysis with an embedded connection with prompting
If you have saved an analysis with an embedded connection with prompting, by default, the end user will not be prompted for input upon opening the analysis. The data selection will be based on the selection that you made in the prompts, when authoring the analysis. Follow these steps to show the prompts and let the end user define variable values, upon opening the analysis.
About this task
Note: Your selection in the prompts, when authoring the analysis, will be the default selection in the prompts to the end user.
Procedure
- On the menu bar, select Data > Data Table Properties.
- In the Data Table Properties dialog, on the General tab, click Linked (individual settings per source).
- Select Prompt for new settings before loading.
- Click OK.