Prompting for SAP BW BEx Variables
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.
In BEx queries, variables are used to limit the data to be loaded. Prompting can bring greater flexibility to a BEx query connection, as you can use it in place of static values for BEx variables. By defining BEx variables via prompts, one connection can be used to load different data from the source depending on the user input.
Some variables are 'Mandatory' and values must be defined before the query can be opened. By setting up prompting, you can let the end user define the variable value, instead of defining it in the connection configuration.
Compared to working with relational data sources, BEx queries are more restrictive regarding how you can set up prompting. When a variable is defined in the query, it is designed to only accept certain input; for example single value, multiple value or range. In Spotfire, the accepted input determines what prompt types you can use for a BEx variable.
- 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. - Details on Prompting for SAP BW BEx Queries
Prompting for BEx queries is defined in the Data Selection in Connection dialog. Click a BEx variable and, in the Settings pane, the following options will be available to define prompting.
- 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. - Details on Prompting for SAP BW BEx Queries
Prompting for BEx queries is defined in the Data Selection in Connection dialog. Click a BEx variable and, in the Settings pane, the following options will be available to define prompting.