Adding Dashboard Filters
Dashboard filters allow users to filter the information displayed on a dashboard. To add a dashboard filter, do the following:
- Open the dashboard.
- Expand the Filters area, and clickAddto add a filter.
- Select the type of filter from the Type menu. Options are Combo, Date or Text. The Combo option provides more than one filter to be applied, such departments and compliance issues.
- Enter a display label for the filter in the Display Label field.
- Enter the parameter name for the filter. This is the name that was entered as the analyzer filter in Adding an Analyzer Widget.
- Specify if the filter allows multiple selections in theIs Multi-Selectlist.
- Select the type of query. The options are MDX/Cube Query or SQL/Database Query.
- Select the connection.
- Enter the server name. This is the server that has the data.
- Select the database.
- (MDX query only) Select the cube to query.
- (Optional) ClickCache Queryto cache the query results.
- Define the query as follows:Modifying an MDX query using the Query Editor invalidates and disables the Query Designer for the widget.
- For an MDX query, select the fields by dragging the field to the Selected Fields area, and entering additional query specifications in the MDX Segments area. The Query Editor can also be used to enter an MDX query.
- For a SQL query, enter a query in the Query Editor area.
- ClickUpdate Query Parametersto update the query key and value fields.
- Select the query key, and the query value.
- ClickSave.
- (Optional) Repeat this procedure for additional filters, as needed.
- ClickSaveto save the dashboard.
Deleting a Dashboard Filter
To delete a dashboard filter, do the following:
- Open the dashboard.
- Expand the Filters area.
- Select the dashboard filter, and clickDelete.
- ClickSaveto save the dashboard.