The Fixed / Dynamic function can supply a fixed or dynamic value to an output node. Static values do not change between task run-times; use recordset columns or variables to create dynamic values that change for each record or task run. Use this function where you want to map variables to the output XML schema that do not form part of the input recordset or XML document.

Fixed / Dynamic functions are available as part of the Data Transformation Layer (DTLClosed When used as part of a BPA Platform tool, the Data Transformation Layer (DTL) extend the tool's functionality by transforming SML from schema to another. In addition, several transformation functions are available for use with the input data before such data is mapped to the destination schema.) feature.

Adding a Fixed / Dynamic Function

Fixed / Dynamic functions are used in the Mapping tab of the following tools:

► Microsoft SQL Server Connector
► Run Microsoft Reporting ServicesClosed The Run Microsoft Reporting Services tool automates the running of Microsoft Reporting Services (MSRS) reports.
► Transform DataClosed Transform Data is a Format tool that enables a new structure to be created from an existing XML or recordset data source. The output generated by this tool is ready for use in a destination system which consumes or requires XML.
► Web Service Connector
  1. Open the relevant task step and go to the Mapping tab.

— Node

— Element

and — Node or element available for mapping

— Mandatory element that must be mapped and included in the output

  1. Click Functions to expand the Functions pane.
  2. Expand the Data node and drag Fixed / Dynamic to the Transformation Mappings pane.
  3. Drag the relevant Input Data source node or element to the new icon.
  4. Do the same for the receiving Output Data node or elements.
  5. Double-click the icon.

The Transformation Mappings pane is replaced with the Fixed / Dynamic's configuration pane:

Data Transformation Layer - Fixed / Dynamic

  1. Enter a meaningful Function Name.
  2. The output (destination) link(s) created previously now appear in the Output tab. If you have more than one connected output, it is recommended you Edit each Parameter in turn and rename it.
  3. To change an existing mapping, either Inputs or Output, use the drop-down lists under Mapped To to select a new node or element.

Specifying a Fixed Value

Fixed values are set at configuration time and persist throughout every task run. These can take the form of literal or constant values.

  1. Go to the Value tab.
  2. In the box provided, enter the required fixed value.

Specifying a Dynamic Value

Dynamic values change each time the task is run, or multiple times throughout a single task run. Values are provided by other task data such as variables, functions, and formulas.

  1. Go to the Value tab.
  2. From the Task Browser, drag the required dynamic parameter to the box provided.

Selecting Error Handling Options

Use the Options tab to define error handling behaviour for this function.

At task run-time, if a dynamic value is unavailable, you can choose to:

► Output an empty String — An empty string is passed to the mapped output node at task run time, for example, <country></country>.
► Output no Data — The element isn't included in the output XML.
► Output Value — Enter a static value in the provided text box; this value is passed to the mapped output at task run-time.
► Error — The function logs an error to the BPA Platform Event Log. Depending on the parent task step's own error handling options, the task can either continue or fail completely.

Click OK to save the function and return to the parent task step's Mapping tab.