Dynamic Prompt :: SAS(R) BI Dashboard 4.31: User's Guide, Second Edition

Definition

A dynamic prompt is a drop-down list (or menu) that consists of selections that can be used to dynamically change another indicator type based on the menu value that is selected.

Example of a Dynamic Prompt Indicator with the Dynamic Radial Thermometer Gauge Selection

For a sample of the indicator data that was used to create this indicator, see “Sample Data Structure” for this indicator.

Usage Information

Data best suited for	Use dynamic prompts when working with unique menu values for which the data related to each value is different and informative enough by itself. An example of a dynamic prompt is when the following values are included in the prompt: 2005, 2006, 2007, 2008, 2009, 2010. Whenever the user selects one of these years, another indicator dynamically changes based on the selection of the year.
Target audience	This indicator type is appropriate for all user audiences. Most people find this indicator type familiar and easy to interpret. Adding KPI indicators to the values in the list provides users with additional information to help them quickly choose among the options given in the list.
Data aggregation support	This indicator type does not aggregate the indicator data.
Range support	Ranges are optionally supported. Note: As of the second maintenance release of SAS BI Dashboard 4.31, a range is no longer required when you create a dynamic prompt indicator. However, the range is required if you select the Combo box with gauge setting.
Alert support	Alerts are supported only if a range is associated with the indicator. For information, see Customizing Alerts.
Link support	This indicator type can be used as the destination of a link only. For more information about defining an indicator with a hyperlink, see Adding Links to Indicators or Other Content.
Interaction support	Data filter support: This indicator can be used as either a source or target indicator. Interactive highlighting support: This indicator does not support interactive highlighting. For more information, see Adding Interactions between Indicators.
Filter multiple items support	Filtering multiple items is not supported.

Note: The dynamic prompt indicator does not use the SAS Prompting Framework and cannot automatically establish dependencies between prompts to create cascading prompts. To achieve similar behavior you must do the following:

Use either an information map or stored process as the indicator data.
Manually create the prompts in the information map or stored process.
Manually create the filter combinations for each dynamic prompt in the indicator data.
Manually define interactions in the dashboard between the prompts. The interactions can be either client-side or server-side, depending on your underlying data needs.

General Settings

The General Settings section provides controls that support the following tasks:

Display Settings

The following display settings are used in the preceding figure. For more information, see “Sample Data Structure” for this indicator.

Display Setting	Selection Used for Figure
Range value	Sale Amount
Range value 2	Sale Amount
Menu value	Country
Prompt type	Combo box with gauge

You can customize the following display settings for this indicator:

From the Range value list, select the value to which you want to apply the defined range intervals.

Note: As of the second maintenance release of SAS BI Dashboard 4.31, you no longer must specify a range when you create a dynamic prompt indicator.
(Required) From the Menu value list, select the parameter to provide the values available in the list in a dynamic prompt indicator.

CAUTION:

If you select Combo box with gauge, ensure that each menu value is unique.

Duplicate menu values cause unexpected behavior.
From the Prompt type list, select the type of prompt to display for a dynamic prompt indicator. As of the second maintenance release of SAS BI Dashboard 4.31, the default setting is Combo box. For more information, see Sample Data Structure.

Note: If you select Combo box with gauge, then you must select a gauge. If you select Combo box, then you cannot select a range.
In the Prompt label field, type the label for the prompt.
From the Prompt label width list, select the width to use, in pixels, for the label. The width of the combo box is reduced by the width of the prompt label.
Click Include (all) selection if you want the prompt to provide a selection that displays all values.

Sample Data Structure

To create a dynamic prompt that is a list box with a gauge, provide values for the menu selections (menu value) and an associated range value for each menu selection (range value), and select Combo box with gauge from the Prompt type list. When including a gauge, make sure that the data is aggregated such that there is only one row for each menu value. For example, in the following data sample, you should not have more than one row of data for each country. Otherwise, the menu will display a selection and gauge for each row and a country with multiple rows will appear in the menu multiple times.

The following data sample is associated with the figure previously shown. Underneath each column heading is its associated display setting.

Country (Menu value)	Sales Amount (Range value and Range value 2)
Canada	$7,334,520
France	$899,771
UK	$1,395,636
United States	$619,852,310

To create a dynamic prompt that is a list box only, provide only menu values and select Combo box from the Prompt type list. Typically, this type of dynamic prompt is used as a source indicator to interact with another target indicator. The target indicator must include a data column with the same values as those specified for the dynamic prompt menu value. The column names do not have to match. However, the values in the columns must match in order for the dynamic prompt to filter the target indicator. For more information, see Adding Interactions between Indicators.