InetSoft Product How-To: Embedded Dashboard Variables

The dashboard software offers embed variables for data sets in order to create custom reports using InetSoft's comprehensive real-time analytical reporting solution dashboard software. View the example below to learn more about the Style Intelligence solution.

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.

embedded dashboard variables

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.

view demo icon
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.

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 cor¬responding 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.

Evaluate InetSoft's Business Intelligence Software for your dashboard and reporting software needs.

Previous: Defining Dashboard Variables