Configuring for Prompts

You can configure settings that affect the way that users work with prompts.

  1. Open the instanceconfig.xml file for editing, located in:

    BI_DOMAIN/config/fmwconfig/biconfig/OBIPS

  2. Locate the sections in which you must add the elements that are described in the table below.
  3. Include the elements and their ancestor elements as appropriate, as shown in the following example: 
    <ServerInstance>
  <Prompts>
    <MaxDropDownValues>256</MaxDropDownValues>
    <ResultRowLimit>65000</ResultRowLimit>
    <AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>
    <AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>
    <AutoCompletePromptDropDowns>
      <SupportAutoComplete>true</SupportAutoComplete>
      <CaseInsensitive>true</CaseInsensitive>
      <MatchingLevel>MatchAll</MatchingLevel>
      <ResultsLimit>50</ResultsLimit>
    </AutoCompletePromptDropDowns>
    <ShowNullValueWhenColumnIsNullable>never</ShowNullValueWhenColumnIsNullable>
  </Prompts>
</ServerInstance>
  4. Save your changes and close the file.
  5. Restart Oracle Business Intelligence.
Element Description Default Value

AutoApplyDashboardPromptValues

Specifies whether to display various fields, as described in the following list:

If true, then

  • The Show Apply Button and Show Reset Button fields are displayed on the Edit Page Settings dialog.

  • The Prompts Apply Buttons and Prompts Reset Buttons fields are displayed in the Dashboard Properties dialog.

  • The Prompt Buttons on Current Page option is displayed on the Dashboard builder's Tools menu.

If false, then

  • The Show Apply button and Show Reset button fields are not displayed on the Edit Page Settings dialog.

  • The Prompts Apply Buttons and Prompts Reset Buttons fields are not displayed in the Dashboard Properties dialog.

  • The Prompt Buttons on Current Page option is not displayed on the Dashboard builder's Tools option.

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:

  • StartsWith — Searches for a match that begins with the text that the user types. For example, the user types "M" and the following stored values are displayed: "MicroPod" and "MP3 Speakers System".

  • WordStartsWith — Searches for a match at the beginning of a word or group of words. For example, the user types "C" and the following values are displayed: "ComCell", "MPEG Camcorder", and "7 Megapixel Digital Camera".

  • MatchAll — Searches for any match within the word or words.

MatchAll

MaxDropDownValues

Specifies the maximum number of choices to display in the following locations:

  • At runtime, in choice lists, check boxes, list boxes, and radio buttons in prompts.

  • At runtime, in the Values list of the Select Values dialog when the user selects the Search option from the prompt values list.

  • At design time in the Values list on the Filter editor and in the Available list of the Select Values dialog that is displayed when the user clicks the Search link from the Value list in the Filter editor.

  • At design time in the Available list of the Select Values dialog that is displayed when the user selects Specific Column Values in the Choice List Values field or Specific Values in the Default selection field and clicks the corresponding Select values button.

  • At design time while working with the Slider User Input type, in the list that is displayed for the Lower Limit, Upper Limit, Default Low Value, and Default High Value fields or when the users clicks the corresponding Search link within any of these fields.

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 — Always shows the term "NULL" above the column separator in the drop-down list.

  • never — Never shows the term "NULL" in the drop-down list.

  • asDataValue — Displays as a data value in the drop-down list, not as the term "NULL" above the separator in the drop-down list.

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