For examples of controls and information on where they can be used, see the chapter “Orientation to Dashboards” in the DeepSee End User Guide.

To add a control to a widget:

For reference, this section lists the control options and describes their purposes.

Not all combinations of these options are suitable. Later sections of this chapter provide recommended configurations for specific kinds of controls.

To reconfigure a control on a widget:

To add a control to filter one or more widgets, add a control as described earlier in this chapter and configure it as follows:

You may optionally type a value into Default Value.

Alternatively, click the magnifying glass. The system displays the following dialog box:

Here do one of the following:

Then click OK.

If you select a runtime variable, it is shown in the Default Value field with an at sign (@) at the beginning. For example: @DefaultZipCode

If you type a value into the Enter an MDX Key field, use one of the following forms:

To add an onclick filter control, add a control as described earlier in this chapter and configure it as follows:

As an example, see the dashboard Listing with OnClick Filter, in SAMPLES. This dashboard is defined as follows:

To add a control to refresh the dashboard (which is necessary if you have controls that set filters but that do not apply them automatically), add a control as described earlier in this chapter and configure it as follows:

You can add controls with which users can print parts or all of the dashboard. The output is a PDF file (opened in a browser window) with one page for each widget.

To add such a control, add a control as described earlier in this chapter and configure it as follows:

Then save the dashboard.

For further details and requirements, see the section “Customizing Print Settings for a Widget.”

To add a control to reload the dashboard, add a control as described earlier in this chapter and configure it as follows:

You can add controls with which users can change the display type from one chart to another. You can provide two different kinds of controls:

To add such a control, add a control as described earlier in this chapter and configure it as follows:

Then select the control again and display the Control menu. Select Chart Type. This displays a list of chart types, which includes the pivot table type. Then:

Then save the dashboard.

In a pivot table widget, if a user double-clicks a column header in a pivot table, the system automatically sorts the pivot table by the data in that column. No configuration is needed for this.

You can also add a control that affects the row or column sort. To add such a control, add a control as described earlier in this chapter and configure it as follows:

For pivot table widgets, to add a control that changes the row or column count, add a control as described earlier in this chapter and configure it as follows:

For widgets that display pivot tables (rather than other data sources), you can add a control that enables the user to change the specification for the rows or columns of the pivot table. To add such a control, add a control as described earlier in this chapter and configure it as follows:

To provide a similar control that provides a list of choices for the row or column specification:

Pivot variables provide another way for your end users to interact with your dashboards. A pivot table can be defined so that its underlying query uses pivot variables in selected parts of the query. (Similarly, an MDX-based KPI can use pivot variables in the same way.) When a dashboard includes this pivot table, that dashboard can include a pivot variable control, with which the user can change the value of the corresponding pivot variable. DeepSee simply substitutes the given value into the query, executes the query, and then redisplays the pivot table.

To add a control to set a pivot variable, add a control as described earlier in this chapter and configure it as follows:

The control is useful only if the data source for the widget uses the given pivot variable.

For a pivot table widget, you can provide a control that displays a different pivot table as the data source. The original data source does not have to be a pivot table. To add a control to display a specific pivot table in a widget, add a control as described earlier in this chapter and configure it as follows:

To provide a similar control that provides a list of choices:

You can display listings from any pivot table widget whose data source defines a listing.

Note that in order to use the Google Maps API, you must obtain an API key. See Specifying Basic Settings in the DeepSee Implementation Guide for more information.

To add a control that displays a listing, add a control as described earlier in this chapter and configure it as follows:

For a widget that displays a pivot table, you can add a control that displays the Pivot Analysis window. To add such a control, add a control as described earlier in this chapter and configure it as follows:

To add a control that displays another dashboard, add a control as described earlier in this chapter and configure it as follows:

To pass values from a dashboard to a web page, include the following tokens in the URL:

http://www.google.com/search?q=$$$VALUELIST

To add a control that displays a web page, add a control as described earlier in this chapter and configure it as follows:

To add a control that performs a custom action, add a control as described earlier in this chapter and configure it as follows:

In some cases, a custom action might require information about the context — that is, the row that the user selected before launching the action. (Other actions operate the same way no matter what the context is.) When you use custom actions, make sure that you know whether this context is required.

If a custom action requires context, do the following to specify which column contains the value to pass to the actions:

Do not select the Value Column option for more than one property or column in the same widget; if you do, the result is indeterminate.

Sometimes it is useful to add a control, specify a default value, and hide it. To hide a control, for Type, select Hidden.