Prompting

In the prompting dialog, you can set values for prompts. Prompts are defined as variables in BEx Query Designer. The variables are parameters of a BW query and are filled with values when you insert a query as a data source in a worksheet. They serve as placeholders for members, hierarchies, hierarchy nodes, formula elements and texts. After defining the variable values, the crosstab is displayed according to the selected values.

To be editable in the prompting dialog, a variable must be defined as input-ready and set to Manual Input in Query Designer. A variable can be defined as mandatory or optional in Query Designer.

The prompting dialog appears automatically when you insert the query with variables in a worksheet. You can open the prompting dialog manually with the prompting icon in the menu to change variable values.

At workbook level, you can select properties to define how the prompting dialog and defined values behave in workbooks. For example, you can define that variable values are saved in a workbook. If you open this workbook again, the data is displayed according to the defined values. You can then open the prompting dialog and change the values.

Defined prompt values can be saved as variant for a query or for a document (workbook or presentation) using the variant dialog in the prompting dialog.

If there are no input-ready variables in the query that you use as your data source, the prompting dialog is disabled.

Note Objects that are defined as input-ready variables in BEx Query Designer are called prompts in Analysis, edition for Microsoft Office. In the following documentation the Analysis term prompt is used for these variables. A query can also contain other variable types. All variables and values of these variables that a query contains, are displayed in the Variables area on the Information tab in the design panel.

To find more information about the definition of variables in the BEx Query Designer, go to the SAP Help Portal at http://help.sap.com Start of the navigation path SAP NetWeaver Next navigation step Select release and language SAP NetWeaver Library SAP NetWeaver by Key Capability Business Intelligence BI Suite: Business Explorer Query Design: BEx Query Designer Reusable Query components Variables End of the navigation path .