Define Filters

Use this screen to define single filter values and filter ranges. A filter is a set of criteria that restricts the set of records returned as the result of a query. With filters, you define which subset of data appears in the result set.

Note Note

Defining filters is usually optional, but depending on the template you have chosen it may be an important step. For the Percentage Share template, for example, you usually need to define filters in order for the business logic to work correctly.

End of the note.

Structure

The main sections and controls of this screen are listed in the following table:

Section	Control	Description
	→ button	Transfers a selected member to the Selected Filter Values list. Repeat to define additional filter values. You may create individual filter values with members from different levels, hierarchies, or dimensions.
	Range → button	Defines a filter range: Select a start member (to indicate the start of the range). Click → to transfer it to the Selected Filter Values list. From the same level in the metadata hierarchy, select the end member of the range. Click Range →. The end member's name is appended to the name of the start member in the Selected Filter Values list, indicating that the range is active.
	← button	Removes a selected filter or filter range from the Selected Filter Values list.
	Clear button	Removes all values from the Selected Filter Values list
Browse tab		Lets you navigate within a metadata hierarchy to the desired member.
	Dimension	Lists available dimensions in the selected cube.
	Hierarchy	Lists available hierarchies in the selected dimension.
	Metadata list	Lists available metadata in the selected hierarchy. Expand the desired level and locate the member or members desired.
Search tab		Allows you to search for a specific member within a selected level. Useful if you are having trouble locating a specific member in your data service, or if you have expanded a level with too many members to display in the list.
	Dimension	Lists available dimensions in the selected cube.
	Hierarchy	Lists available hierarchies in the selected dimension.
	Level	Lists available levels in the selected hierarchy.
	Search	Type the name of the member you wish to find into this field. The field also functions as a drop-down list, which you can use to select from the history of searched members.
	Search button	Searches for the member entered in the Search field.
	Metadata list	Displays a list of members found, with both Caption and Unique Name.
Selected Filter Values		Lists the selected individual filter values or filter ranges.
Filter Details		Displays details about a selected filter or filter range.