Report filters allow you limit the amount of data that is brought back in your query to specifically the information that you require.
You may decide that you don't want to include all the data in a document. Applying conditions or filters to queries allows you to include only the data you need. The following illustrations show how a condition or filter works.
Yellowfin lets you setup a variety of filters for your reports. These filters can be pre-set so that every time a report is run, the same conditions are used; or alternately, a user prompts can be created to allow a user to select the data filter when they run a report.
Filters Types Available
There are a number of filter types available when building a report. These include predefined filters, user defined which includes the ability to create user prompt or parameter driven reports.
Predefined filters can be created to assist users with adding filters or conditions to their reports that ensure the data they require is easy to extract.
The use of predefined filters is especially useful in instances where:
- A common set of filters are used by report writers - such as location, or business unit; or
- If there are particularly complex filters that can be built ahead of time and are commonly used.
Predefined filters are indicated by the icon used in the data field list. This is indicated by the filter icon. To include a predefined filter on your report select an item from your report data menu. As shown below.
You will not be able to edit the contents of the filter once it is included in your report. If you wish to do so then creating a user defined filter as described below is required.
User Defined Filters
If you wish to create your own filters from the data available to you in your view then you will have to create a user defined filter.
- The first step in adding a filter to your report is to drag either a dimension or metric item from the data fields list into the Filters Box as seen below.
- On the filter management page (discussed below) you will then be able to set the values for these filters.
User Prompt Filters
User prompt filters or parameter driven reports can be created by creating user defined filters. If you do not specify particular values for the filter as discussed in detail below then the filter will be displayed on the report as a user prompt.
Parameters are a special type of field which allows you to user input into calculated fields or have a single user prompt for multiple filters requiring the same input value. A parameter differs from a standard filter in that the input values can be used for calculations which permit you to do what if analysis.
For example a standard filter for Revenue would limit the result set to a specific revenue value - e.g. Greater than $100. However, a parameter could be used to drive a calculation - Multiply current sales units by $100.
Parameter fields are defined at the view but can be applied to report calculations and filters.
Parameter fields are indicated by the icon used in the data field list. This is indicated by the blue filter icon.
The access filter is a global filter applied to a report based on the user that is viewing the report at the time. This filter allows the same report to be distributed / used by many people but will only display data that is relevant for them.
For example an access filter may associate the user as the manager of a particular cost centre. When that user runs the report they will only see data for the cost - they will not be able to view data for other cost centres.