Embedded Dashboard Variables
To create an embedded list for a Variable, follow these steps:
1. Right-click the Variable asset, and select the 'Properties' option from the context menu. This opens the 'Variable Properties' dialog box.
2. In the 'Selection List' panel of the 'Variable Properties' dialog box, select the 'Embedded' option.
3. Click the 'Edit' button to open the 'List' dialog box.
4. Click 'Add' to create a new label/value pair. A label/value pair defines a particular choice that will be shown to the user in the input dialog box.
5. In the 'Label' field, enter the text that should be displayed to the user for this particular choice.
6. In the corresponding 'Value' field, enter the text that should be used in the filtering condition for this particular choice. (If the 'Type' option in the 'Variable Properties' dialog box specifies a numeric type, you can only enter numerical values.)
7. Repeat the previous three steps to add all the choices that should be presented to the user.
8. To change the position of a item in the list, select the item, and click the 'Up' or 'Down' arrow button.
9. Click 'OK' to exit the 'List' dialog box.
Creating a Query-Based Variable List
To populate the Variable selection list with data obtained from a query (table), follow these steps:
1. In the 'Selection List' panel of the 'Variable Properties' dialog box, select the 'Query' option.
2. Click the 'Select' button to open the 'Table' dialog box.
3. From the list box on the left side, select the table that contains the data you wish to use.
4. From the 'Value Column' menu, select the column that contains the data to be used in the filtering condition. Each row of the 'Value Column' represents a possible value of the Variable.
5. In the 'Label Column' menu, select the column that contains the labels to be displayed to the user.
Each row of the 'Label Column' should contain the label for the corresponding row of the 'Value Column'. These labels are used to desig¬nate the available options in the 'Enter Parameters' dialog box that will be displayed to the user. When the user selects a particular option, the value corresponding to the selected label is applied to any filter conditions that use the Variable
6. Click 'OK' to exit the 'Table' dialog box.