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

  1. You can select a value with the Match Code (List of value)  or directly insert a value.
  2. Prompts marked with a * are mandatory.
  3. Ok is ungrayed when mandatory fields are correctly filled in 



Selecting multiple values 

You can select multiple members as the prompt values for this dimension.

  1. Press the button , to add a field for additional values.
  2. To remove a selected member, press the button 

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:

  1. In the Prompt, Select « + » and choose « Add Lines using Filter By Member ».

  1. In the Pop up of the selection, untick first Select All.
  2. Open Display button to choose the correct type either you want to copy text, or Key,  
  3. In the Pop up of the selection, click to the button to « Paste from clipboard ».



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 : I want to search all the Company codes that contain Z and R, therefore I just replace the « * » in the name Z*R*  => result  = ZBR1, ZFR3 & ZFR9



Selection option 

You can select an operator and corresponding members to define a selection for this dimension. The following operators are available:

=Equal To<=Less Than or Equal To
!=Not Equal to[ ]Between
>=Greater Than or Equal To![ ]Not Between
>Greater ThanCPContains Pattern
<Less Than!CPExcludes Pattern



Selection of all values

To select all the values of a mandatory variable, enter the value : >= # (greater or equal to "#", as"#" is the lowest value that can be found in the system)

Example : I want to have a report with all plants and the variable "Responsible Plant" is mandatory.  Enter the value : >= # to select all plants


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

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


Modifying variants

  1. Enter the new values in the prompt
  2. Save the new variant 
  3. Click 

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.