2 Multi-Select Dashboard Prompts Feature

This new feature enables users to analyze data more easily with an easier to use and more powerful screen for specifying dashboard prompts. For example, users can now use multi-select to specify prompt values, and a more powerful search facility.

Prior to this release, a multi-select dashboard prompt with a large number of values could become difficult to work with. A new search feature adds the ability to better navigate and select values from a multi-select prompt when there are many (possibly hundreds or thousands) of values. Modifications to the existing multi-select dashboard prompt now allow the user to search through the available values using four matching schemes: begins with, ends with, contains, and is Like (Pattern Match). Wildcards like % can also be used in the query. A more sophisticated paging mechanism is also now present which allows the user to page ahead according to a configured search set size as needed. A plus sign following the "Choices Returned" number and the "More..." button indicate additional values have not yet been shown. Configurations for the search set size are described below.

As with the previous multi-select prompt, to add values to be filtered, choices are selected and moved via the shuttle buttons to the left pane. A single mouse click selects a single value. Multiple values can be selected by clicking while holding down the Ctrl key. Range selection is done by holding down the Shift key while clicking. Buttons then allow the user to move single values, these sets of values, or all visible values to or from the "Selected" pane.

Once in the "Selected" pane, the collection of values may be edited by clicking on the Edit button. This action will show an editable dialog where new values could be typed in or lists of values could be copied and pasted in or out of the prompt. A list of values in Excel, for example, could easily be pasted in and thus "imported" into the prompt. This edit dialog will interpret sequences of values separated by carriage returns/line feeds, tab delimiters, and/or pipe (|) characters. Please also note that while manually typing in values, only carriage returns/line feeds and "|" can be used as value separators. Tab is a valid value separator only when user copy pastes values, which are tab, separated.

2.1 Configuration for the Multi-Select Dashboard Prompts Feature

This section explains how to configure the Multi-Select Dashboard Prompts feature.

For configuration, instanceconfig.xml can be edited to specify the number of values returned per search set. The following "Prompts" node will need to be added under the "ServerInstance" node:

<Prompts>
<MaxScrollValues>20</MaxScrollValues>
</Prompts> 

Please see the "Making Oracle BI Presentation Services Configuration Changes" section within the Oracle Business Intelligence Presentation Services Administration Guide for more information on editing the instanceconfig.xml configuration file.