Summary


This article describes methods for supplying parameter values to an XDC data source.


 Source


Use a database query or File List data source to supply parameter values.


Requirements

  • The data source must contain a column for each document parameter
  • Column names must either match parameter names or column names are aliased to match parameter names. There are two aliasing options:
    • Use Parameter Alias to alias the column name with the parameter name
    • When using a database query, use the select statement to select the column name as the parameter name.
      • Example: SELECT State AS 'Enter value(s) for State:')

Usage Example


In this example, the document contains two parameters:

  • Enter value(s) for Customer State:
  • Enter value(s) for Division:

The data source contains corresponding columns with mismatched column names.

 


state division
Arizona Sales
California Development

Using Parameter Alias where Enter value(s) for Customer State: = state and Enter value(s) for Division: = division, the following select statement can be used:


SELECT state,division FROM table


Without Parameter Alias, the column names must be aliased with the select statement:


SELECT state as 'Enter value(s) for Customer State:',division as 'Enter value(s) for Division:' FROM table


When using an Excel File List, column names must match or Parameter Alias must be used as query aliasing is not available.


Apply a Source

  • Select the Burst document
  • Select Data Links > Document Source
  • Source: Select the ellipsis button
  • Select a data source
  • Parameters (if applicable):
    • Database query syntax: @=[VALUE]
    • Excel File List syntax: [COLUMN]='[VALUE]'
  • Delimiter: Set the delimiter character for multiple values as required by your reporting platform
  • Select the Apply button
  • Error Source does not contain a match for... will occur if the data source does not contain columns for each document parameter.

 Per Parameter


Supply parameter values manually.

  • Unique Parameters: Select a parameter
  • Values: Enter the value(s) to supply to the parameter
  • Delimiter: Set the appropriate delimiter character when providing multiple values to a parameter
  • Multi Pass: Check to refresh data source once for each parameter value

Filtering


Filtering is used to define a report-level variable on which to single-pass burst. This option is only available for Web Intelligence reports. A list of values from the refreshed report will be used to filter the resulting data.

  • Filtering using values from variable: Select to enable filtering
  • Select a report-level variable on which to filter

Bursting


Bursting a data source with a parameter or filter will result in unique sub-caches of data. The data is bursted on a key parameter known as the Cache Key. The unique sub-cache can be embedded in a dashboard (SWF) for offline delivery. The cache key can also be used in combination with dashboard security to server specific sub-caches to specific (connected) dashboard viewers.


When using Source and multiple parameter values, the data source is bursted (multi-pass) by default. When using Per Parameter the 'Multi Pass option must be checked to burst the data source and produce unique sub-caches.