Summary
This article describes the various options for supplying values to a document filter for single-pass bursting. Filtering is available for Web Intelligence, Crystal Reports, and Tableau.
Access
- Select the Burst item
- Expand the Filters panel
- Select the + icon to add a filter
- Select a filter variable
- Select the Add button
- Select the Filters tab
- Select a source for filter values
BusinessObjects Report Variable
Report Variable uses values from the refreshed report data for Web Intelligence and Crystal Reports filtering. Use this option when the requirement is to filter for all variable values available in the report.
Select the Exclude button to exclude one or more values from the Report Variable list.
Multiple Filters
Report Variable is only supported for a single filter. The BusinessObjects SDK does not support Report Variable for additional filters. Filter values for additional filters must be supplied manually or via Data Source.
Warning: Supplying an invalid value to a secondary filter will result in BusinessObjects producing output that contains ALL DATA. This is a known BusinessObjects issue. We strongly recommend avoiding secondary filters unless you can ensure the values you supply are valid. |
Data Source
Use a Data Source to provide filter values. Select the Data Source button then select a Data Source.
- Select the Database Query
- Parameters (if applicable):
- Database query syntax: @<PARAMETER>=<VALUE>
- Excel File List syntax: <COLUMN_NAME>='<VALUE>'
- Delimiter: Set the delimiter character for multiple values as required by your reporting platform
- Column: Query column to use if the query returns multiple columns
- Select the OK button
- Multi Pass: Select to refresh once for each value in a list of values. Option is only available if the parameter type is in-list.
- Select the MultiColumn List
- Column: Column to use if the MultiColumn List contains multiple columns
- Condition (if applicable): Syntax <COLUMN>='<VALUE>'
- Select the OK button
- Multi Pass: Select to refresh once for each value in a list of values. Option is only available if the parameter type is in-list.
File List
- Select the File List
- Column: Column to use if the File List contains multiple columns
- Condition (if applicable): Syntax <COLUMN>='<VALUE>'
- Select the OK button
- Multi Pass: Select to refresh once for each value in a list of values. Option is only available if the parameter type is in-list.
Enter Value
Select the Enter Value(s) button to enter filter values manually.
See Also