You can select various workbook properties in the design panel that affect the behavior of the prompting dialog and existing prompt values:
If you select this option, the data sources in the workbook are refreshed every time the workbook is opened. The behavior of the prompting dialog depends on the other properties you selected for this workbook.
If this check box is not selected, the data in the workbook is not automatically refreshed on opening. You can refresh the data sources manually by choosing Refresh All in the menu.
If you select this option, the prompting dialog is displayed every time you refresh. The dialog appears even if the query only contains optional prompts. If values are already saved with the workbook, these are displayed as predefined settings in the dialog. You can accept or change these values. A refresh happens when you open a workbook and select refresh, when you select the setting above and open a workbook or when you insert a new data source.
If this property is not selected, the system checks whether the workbook contains mandatory variables that no values are available for. If no values are available, the prompting dialog is displayed. If values are available, the workbook is displayed straight away.
This is the default property. If it is used, the defined prompt values for characteristic value variables are saved with the workbook. These variables are defined in the Characteristic Restrictions area in the BEx query designer.The stored values will be applied to the data when the workbook is refreshed during the current session or closed and opened again. The prompt values are also available to other users using the workbook. To change the values, you can open the prompting dialog manually.
If this property is not selected, the defined values will not be saved with the workbook.
If you select this option, all prompts in the workbook are listed in the Prompts dialog. You can define values for each prompt. These prompt values are valid for all data sources that contain the prompt.
If this property is not selected, the data sources in the workbook are displayed in the Prompt Summary area of the Prompts dialog, and the corresponding prompts are listed in the Specify Value for Prompts area. You can define different values for the prompts for each data source.
Every time you change your selection for this property in the workbook, the connected data sources are restarted. The prompting dialog will therefore appear automatically so that you can define the values before the data sources are refreshed. If the data sources are not connected, the dialog will not appear, and only the property will be changed.
The behavior of the prompting dialog and saved prompt values will be in accordance with your workbook properties selection.