Burst Output Settings: Destination Tab
The last step in the Burst calculation wizard is to set up the destination, either an Email or Save to Destination.
Using the visual assist for To, pull in the dynamic variable email address if there is a column in your driver report to represent who the sub-report for that row will be emailed to. You could also manually type specific email addresses, but this would require manual maintenance for the list if changes are needed in the future.
Enter a Subject using dynamic variables, e.g. Report Name.
Enter the email body using dynamic variables from the Insert Token assist button if needed, e.g. First Name.
Tokens Available for Distribution
| Token | Value |
|---|---|
| <TIMESTAMP> | The TIMESTAMP token is reevaluated for each row bursted. This means that when bursting multiple rows, the timestamp will be different for each row. But if used in multiple places, for example the file name and output directory, the value will be consistent within that bursted row. |
| <TODAY> | The TODAY token is reevaluated each time it is used, so the value may change if task execution begins directly before midnight. |
| <NOW> | This value is evaluated once when bursting starts. When bursting multiple rows, the evaluated value of this token should be consistent. |
| <UTCNOW> | This value is evaluated once when bursting starts. When bursting multiple rows, the evaluated value of this token should be consistent. |
| <USER> | Logged in user |
| <STATUS> | Success or Failure |
| <STATUSCODE> | Status code |
| <REPORT> | Name of the report added to the burst calculation |
| <REPORTOUTPUT> | HTML output of the report or ProReport. This is used for embedding the report in the email body. |
| Data tokens | When clicking Insert Token, this includes anything under the Data category. |
| System tokens | Tokens beginning with SYS_USER. These are based on the signed in user's JDE system. |
Embedding a Report Output in an Email Message
In an email distribution, there is the option to embed the report into the email body using the <REPORTOUTPUT> token. This is supported for ProReport and data HTML, but not Excel Presentation HTML.
The HTML output type does not need to be selected for this to work, although it is possible to both select the HTML output type and insert the <REPORTOUTPUT> token if you want HTML both embedded and attached. Or, for example, you can attach a PDF and embed the HTML in the email.
When embedding a ProReport output with images, by default, images in the ProReport will be integrated as inline attachments in the email using a standard MIME protocol to ensure images render properly. Another option is to encode images directly in the email body by adding a parameter to the REPORTOUTPUT token: <REPORTOUTPUT Image=Encode>. Images will then be base64 encoded, and their appearance and rendering are determined by your email provider's handling of this encoding method and may not show up in emails if their size is too large.
Note
In the case of multiple REPORTOUTPUT tokens being inserted into the email body, if even one of them is using Image=Encode, then images will be encoded for every REPORTOUTPUT token in that email.
Warning
DAS does not limit the size of the email body, so inserting large reports as <REPORTOUTPUT> can cause the email application to become unresponsive during rendering.
Including Dynamic Links in Burst Distributions
To learn how to include hyperlinks dynamically in burst distributions, review the Hyperlink documentation.
Save to Destination
Users may also select to have a distribution report go to an output directory in lieu of email distribution. This directory allows reports to be referenced by those outside of DAS who have access to the file location. Not all users may have a DAS Subscriber or Designer license but may still need access to report outputs.
Note
If choosing this option, determine whether the earlier step for the File tab of the Burst Output should include the timestamp as part of the <REPORT>_<TIMESTAMP> name. If you want to overwrite a previous version in the output directory, exclude the timestamp so the original file is overwritten. Think about your auditor requirements.
After you Save the burst calculation, notice that a new Burst column appears in the report. A Bursting drop down menu also appears.
Note
While the use of the '&' in a folder name is allowed, it is not allowed in the file name. The '&' along with other illegal characters will be automatically converted to '_' characters.