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



Add a Filter
  • 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. 



Database Query
  • 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.

MultiColumn 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.




Document Source

To use Document Source with a filter, set the filter variable then set source as Report Variable. Application of Document Source then overrides Report Variable.



See Also


Processing Methods (Single-Pass Bursting)

Using Document Source