A reference field interactive filter allows users to filter report widgets based on
the value of a reference field.
Role required: hp_publisher_admin and report_admin. The
hp_publisher_admin role exists only for managing interactive filters. By default, it
contains no other roles and is not contained in any other roles.
You must have Performance Analytics to create
new interactive filters.
If the interactive filter
has a default value or specifies the last selected value, this value is not applied
automatically on non-responsive dashboards. This feature is only available on Responsive
Repeat steps 8-11 as needed for each reference field you want to filter on. After
you create the filter, add it to a homepage or dashboard.
In the Filter based on choice list, select
In the Reference table choice list, select the table
that stores the referenced records you want to filter on.
Select a Default value for the filter.
This default is applied automatically for all users. If a user selects a
different value, that value is saved as the user's default and overrides the
global default. You can specify more than one default value when using a UI
control type that enables multiple selections, such as Select
Set the following fields:
||Enter a name for the filter. This
name appears on the dashboard widget for the
|Look up name
||Enter a lookup name for the filter. This name appears in
the Add content menu for users adding
a filter to a dashboard. Use this name to help organize your
filters. If you do not specify a lookup name, the
Name value is used
||Enter a description of the filter.
|UI control type
||Select how the available filtering options for this
filter appear on the dashboard widget. See Available interactive filter UI control types.
Select Apply to all tables in hierarchy to apply the
filter to parent, child, and sibling tables of an extended table. For more
information, see Apply interactive filters to all tables in a hierarchy.
Right-click on the form header and select Save.
In the Interactive filter references related list, click
In the Reference table field, select a table that has
reports you want to filter.
Select the Reference field to filter on.
The field must reference the table specified in the parent filter
Reference table field.
You can dot-walk from fields that reference other tables. For example, if the
parent filter Reference table is Department
[cmn_department], you can select Incident as the reference
Reference table, then select Caller
Department as the Reference
Note: A filter may be converted
from the Check boxes to the Select Multiple
Input control type for performance reasons.