Adding Dashboard Filters

Dashboard filters allow users to filter the information displayed on a dashboard. To add a dashboard filter, do the following:
  1. Open the dashboard.
  2. Expand the Filters area, and click
    Add
    to add a filter.
  3. 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.
  4. Enter a display label for the filter in the Display Label field.
  5. Enter the parameter name for the filter. This is the name that was entered as the analyzer filter in Adding an Analyzer Widget.
  6. Specify if the filter allows multiple selections in the
    Is Multi-Select
    list.
  7. Select the type of query. The options are MDX/Cube Query or SQL/Database Query.
  8. Select the connection.
  9. Enter the server name. This is the server that has the data.
  10. Select the database.
  11. (MDX query only) Select the cube to query.
  12. (Optional) Click
    Cache Query
    to cache the query results.
  13. 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.
  14. Click
    Update Query Parameters
    to update the query key and value fields.
  15. Select the query key, and the query value.
  16. Click
    Save
    .
  17. (Optional) Repeat this procedure for additional filters, as needed.
  18. Click
    Save
    to save the dashboard.

Deleting a Dashboard Filter

To delete a dashboard filter, do the following:
  1. Open the dashboard.
  2. Expand the Filters area.
  3. Select the dashboard filter, and click
    Delete
    .
  4. Click
    Save
    to save the dashboard.