1. Creating Analyses and Dashboards in Oracle Transactional Business Intelligence
  2. Report Data
  3. Prompt in Analyses and Dashboards
  4. About Prompts Auto-Complete

About Prompts Auto-Complete

Auto-complete functionality for prompts suggests and highlights matching prompt values, as the user types in the prompt selection field.

Auto-complete is only available for the Choice List prompt type when the prompt designer selects Enable User to Type Value in the New Prompt dialog. Note that auto-complete isn't available for hierarchical prompts.

The auto-complete functionality is case-insensitive.

The matching level determines how Oracle Business Intelligence matches the column's values to what the user types. The matching level is set to Match All.
  • Match All — As the user types, Oracle Business Intelligence suggests the column values that contain any letter that the user types. For example, auto-complete is case-insensitive and the matching level is Match All and the user types "l," then Oracle BI suggests "LCD 36X Standard," "LCD HD Television," "7 Megapixel Digital Camera," and "Plasma HD Television."

The auto-complete functionality highlights matching values when the user accesses the Select Values dialog to search for a prompt value. However, the matching level isn't determined by the preference set by the administrator. Instead, the user selects the matching level in the Select Values dialog.

The dashboard designer can exclude the auto-complete functionality from dashboards, and users can turn auto-complete off by using the My Account dialog. Note the following relationships between auto-complete settings:
  • Dashboard Setting — If auto-complete is enabled for Oracle Business Intelligence, then the dashboard designer can remove the auto-complete functionality from individual dashboards by setting the Prompts Auto-Complete field to Off in the Dashboard Properties dialog. However, the auto-complete prompts functionality is available for other dashboards where the Prompts Auto-Complete setting is set to User Preference.
  • User Preference Setting — If auto-complete is enabled for Oracle Business Intelligence and for individual dashboards, users can disable the auto-complete prompts functionality for their accounts by setting the Prompts Auto-Complete field in the My Account dialog: Preferences tab to Off. Setting this option to Off overrides the system and dashboard settings, and auto-complete functionality isn't displayed for the user