Skip to main content

Display attribute values as links

Attributes that represent entities accessible through other webpages, such as records in the source ERP, can be displayed as clickable links in reports. Set the attribute's reporting type to Link, then configure a link template that defines the URL.

A link template is a URL containing tokens enclosed in braces (for example https://example.com/customers/{id}). When the link is built, each token is replaced with the value of a column from the same pipeline. Each mapped column must be a property of the link attribute (see Requirements for mapped columns).

The Properties panel showing the link configuration and token-to-column mappings

  1. On the model resource screen, select the pipeline containing the column.
  2. Click the column to select it. The column information appears in the Properties panel.
  3. In the Properties panel, make sure Attribute is enabled for the column.
  4. Set Reporting Type to Link.
  5. Under Link template, select the parameter that contains the URL template, or select Custom to enter the template directly.
  6. If you selected Custom, enter the URL template in the Template value box (for example https://example.com/{token}).
  7. Under Link format attributes, map each token in the template to a column. The selected column supplies the value that replaces the token when the link is built.

After publishing and processing, the attribute's values now appear as links wherever the attribute is shown in a report. See Header links for more information about how link attributes are displayed in tables.

A report with the attribute's values rendered as links

Requirements for mapped columns​

For a column's value to be available wherever the link attribute appears in a report, each column you map to a token must be a member property of the link attribute:

  • The column must be enabled as an attribute.
  • The column must be a property of the link attribute. Columns are properties of the pipeline's key attribute by default, so if your link attribute is the key (the most common case), mapped columns work without further setup. If the link attribute is not the key, set each mapped column's Property of to the link attribute. See Attribute columns.

Attribute columns reference

How to work with columns