Configure for Prompts

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

You can also set in the Console, see Prompt Options.

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 Analytics Server.