Prompts Auto-Complete

Oracle BI provides auto-complete functionality for prompts, which 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 selected the "Enable User to Type Value" option in the New Prompt dialog. Note that auto-complete is not available for hierarchical prompts.

The auto-complete functionality has been configured to be case-insensitive.

The matching level determines how Oracle BI matches the column's values to what the user types. The matching level has been set to Match All.

  • Match All — As the user types, Oracle BI EE suggests the column values that contain any letter that the user is typing. 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 is not 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 user can turn auto-complete off by using the My Account dialog. Note the following relationships between auto-complete settings:

  • System Setting — The administrator modifies the system configuration file to enable the auto-complete functionality for Oracle BI. When this functionality is turned on, all users can access the auto-complete prompts functionality. If this functionality is turned off, then all auto-complete fields are disabled on the Oracle BI user interface. Auto-complete is enabled.

  • Dashboard Setting — If auto-complete is enabled for Oracle BI, 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 will be 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 BI 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 no auto-complete functionality will appear for the user.