Summary


This article describes methods for supplying parameter values to an XDC data source and assigning a filter for cache bursting.



Enter Parameter Values


Enter parameter values manually (semicolon separated).

  • Enter one or more values in the parameter field
  • Select the M icon to supply date values using Date Macros
  • Multi-Pass: InfoBurst will burst to create one cache block (key) per value. Un-check the option to create a single cache for all entered values.



Parameter Values from Data Source


Supply values from a Data Source like a Database Query or Excel File List. 


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.

 


statedivision
ArizonaSales
CaliforniaDevelopment

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 Data Source button
  • Select a Data Source
  • Parameters (if applicable):
    • Database query syntax: @=<VALUE>
    • Excel File List syntax: <COLUMN>='<VALUE>'
  • Select the OK button
  • Error Source does not contain a match for... will occur if the data source does not contain columns for each parameter.



Cache Key


When the source contains multiple parameters and is refreshed for multiple values, designate which parameter should be used to segment the cache.



Filters


Filtering is only available for a Web Intelligence source which contains no parameters. Assign a filter to burst and create one cache block (key) per value.

  • Select the + icon to add a filter
  • Select a filter variable then select the Add button



Cache Bursting


Bursting a data source with a parameter or filter will result in one cache block per bursting value. The parameter or filter on which the source is burst is called the Cache Key. The cache can then be consumed by key rather than consuming the entire cache.


Cache URL Access

The cache can be accessed via URL based on cache configuration:
  • Cache: http://[SERVER]:8551/infoburst/rest/get/xdc/[XDCID]
  • Cache with Key: http://[SERVER]:8551/infoburst/rest/get/xdc/[XDCID]?k=[VALUE]
  • Cache Query: http://[SERVER]:8551/infoburst/rest/exec/xdcqry/[XDCID]?q=[QUERY]
  • Cache Query with Parameter: http://[SERVER]:8551/infoburst/rest/exec/xdcqry/[XDCID]?q=[QUERY]&[PARAMETER]=[VALUE]



See Also


Create an XDC