The Prompt values that you enter when running a query can
be saved to this query.
About this task
The Save prompt values function
provides you with the ability to use the last saved value as a default
in the Prompt Variables window next time you
run this query.
When you use a dynamart or compound dynamart
with prompts, the prompt values that you enter are always saved within
this dynamart.
If you decide to save prompt values, be aware
that any user can see the last prompt value in the Prompt
Variables window and run the query with this value as default.
To save prompt values within a query:
Procedure
- With an active query in the editor, select .
- In the Manage Prompts window, select Save prompt values check box. If the check box is cleared,
the prompt values are not saved and you are to enter the prompt value
anytime you run the query. If the check box is selected, you can view
the last value in the Prompt Variables window
and use it as default.
Note: When you use prompts with dynamarts and compound dynamarts,
the Save prompt values check box is always
selected and cannot be cleared.
- Click OK to close the window.
- Run the query by clicking Run Query on the toolbar.
- In the Prompt Variables window, input
the value that you want the query to run with.
- After the query is run, save it to a repository or file
system.