You can configure settings that affect the way that users work with prompts.
Element | Description | Default Value |
---|---|---|
AutoApplyDashboardPromptValues |
Specifies whether to display various fields, as described in the following list: If true, then
If false, then
|
true |
AutoSearchPromptDialog |
Specifies whether search results are displayed and highlighted when the user types the search parameter (without clicking the Search button). |
true |
CaseInsensitive |
Specifies whether the auto-complete functionality is case-insensitive. If set to true, case is not considered when a user enters a prompt value such as "Oracle" or "oracle." If set to false, case is considered when a user enters a prompt value, so the user must enter "Oracle" and not "oracle" to find the Oracle record. The system recommends the value with the proper case. |
true |
Matching Level |
Specifies whether the auto-complete functionality uses matching to find the prompt value that the user enters into the prompt field. These settings do not apply when the user accesses the Search dialog to locate and specify a prompt value. Use the following settings:
|
MatchAll |
MaxDropDownValues |
Specifies the maximum number of choices to display in the following locations:
|
256 |
ResultsLimit |
Specifies the number of matching values that are returned when the auto-complete functionality is enabled. |
50 |
ResultRowLimit |
Specifies the number of records returned from the logical SQL for prompts (analyses and dashboard prompts). |
65000 |
ShowNullValueInPromptsWhenDatabaseColumnIsNullable |
Specifies whether to show the term "NULL" at runtime in the column prompt above the column separator in the drop-down list when the database allows null values. Use the following settings:
|
always |
SupportAutoComplete |
Enables or disables the auto-complete functionality of prompts. A setting of true turns auto-complete on, which means that the Prompts Auto-Complete field is displayed and is set to On in the My Account dialog and in the Dashboard Properties dialog. A setting of false turns auto-complete off, which means that the auto-complete fields in the My Account and Dashboard Properties dialogs are not available. |
false, unless you are running Oracle BI EE on the Oracle Exalytics In-Memory Machine |