| Table of Contents | ||
|---|---|---|
|
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.
info
| Expand | ||
|---|---|---|
| ||
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 :
|
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
- ungrayed when mandatory fields are correctly filled in
Selecting multiple values
You can select multiple
members as the prompt values for this dimension.
- Press the button
, to add a field for additional values. - 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
:
* only available with version 25
Copy the list from a Text. Example FRANCE and US- In the Prompt, Select « + » and choose « Add Lines using Filter By Member ».
- In the Pop up of the selection, untick first Select All.
- Open Display button to choose the correct type either you want to copy text, or Key,
- 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 Than | CP | Contains Pattern |
| < | Less Than | !CP | Excludes Pattern |
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 toSelection of all values
To
select all the values of a mandatory variable,
Solution: Please select the value :
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
Once you have entered all the prompt values, you can save them in a Variant :
- Enter the values for the prompts
- Enter a meaningful name for your variant
- 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
- In a Prompt, Click The Setting Button, choose your « Use Variant ».
- Choose your Variant then click the Modify button
- Choose a Type
| Note | ||
|---|---|---|
| ||
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. |
- Save
Modifying variants
- Enter the new values in the prompt
- Save the new variant
- 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.
