The Prompt window

When you insert a query, or click on refresh, or on the "Prompts" menu, the "Prompts" window will open. This is where you can select the data you want to display the report.

 

If you have multiple queries in the workbook and the option merge variables is unticked (design panel>components) , then you have the option to select between :

  • Prompt for Workbook : It will show in the same prompt window the prompts for all the queries in the workbook
  • Prompt for Data Source : it will show only the prompt for the query that you have selected.

 

Selecting Values

  • You can  select a value with the Match Code (List of value)  or directly insert a value.
  • Prompts marked with a * are mandatory.

  • Ok is ungreyed when mandatory fields are correctly filled in 

Selecting multiple values from Clipboard or a File

In the Prompt, you’ll be able to make a  multiple selection from a list that you can paste from Clipboard or from a file* :

* only available with version 25

  1. Copy the list from a Text. Example FRANCE and US
  2. In the Prompt, Select « + » and choose « Add Lines using Filter By Member ».
  3. In the Pop up of the selection, untick first Select All.
  4. Open Display button to choose the correct type either you want to copy text, or Key,  
  5. In the Pop up of the selection, click to the button to « Paste from clipboard ».
  6. Version 2.5 :   to copy from file click the icon symbolizing a folder . 

Searching for a group Member  with selection (*)

By selecting « * » replacing the missing character, you’ll be able to find a number of member of your search.

Example: In the Customer selection, I want to search for all the Company that contains Z and R in the company name, therefore I just replace the « * » in the name Z*R*  => result  = ZFR2 / ZFR3 / ZFR6 / ZFR7 …

You cannot make multiple search with « , ; + . )


Selection with exclusion 

By selecting « != » or « ![ ]  CP !CP » you can exclude data individually or by range.

!= means not equal to 

CP = Contain Pattern => possibility to use the wildcard *  

 

 

Selection of all values

For security or performance reasons, some variables are mandatory.

If you want to select all the values of a mandatory variable, it's not possible to let the variable empty: the system will detect that you did not select any value and return you an error.

 

Solution: Please select the value : >= # (greater or equal to "#", as"#" is the lowest value that can be found in the system)

 

View the prompt values in Analysis

Once the report is executed you can check the values of the prompts (and filters) in the "Information" Tab 

Using Variants

Save Prompt values into as a Variant

Once you have entered all the prompt values, you can save them in a Variant :

  1. Enter the values for the prompts
  2. Enter a meaningful name for your variant
  3. Click on Save 

 Nota : If the "Use variant" is greyed you need to open the component panel (Design Panel), and unclick the Merge variables option.

 

Modifying variants

  1. In a Prompt, Click The Setting  Button, choose your « Use Variant ».
  2. Choose your Variant then click the Modify button  
  3. Choose a Type

If you choose "Global Type" then you need to enter a technical name (code) and the variable will be accessible by ALL BW users of this query.


Using Variants

To apply an existing variant, simply click the list of available Variant and select your Variant 

The values saved in the variable will replace the existing prompt values.