Overview
Note: If broadcasting or sharing reports with tabbed co-display content, you must first export the report into an XLSX file, and then schedule the broadcast. You need not use the exported file, but simply create a copy.
1. Ensure your report is Active (not in Draft Mode)
2. Click the Broadcast button in the main navigation menu
3. Click Create New and select the Broadcast (or Personal Broadcast) option.
4. The Broadcast window will open, providing you with the following options:
Recipients
Note: this step is not available for personal broadcasts.
1. Click in the Recipients box.
2. From here you are able to search through Yellowfin Users, Groups, and Reports, or type in an external email address (external users require a multicast licence).
User | A person that is a registered user of Yellowfin. |
|---|---|
Group | A group of users that have been setup within Yellowfin. This option allows you to send a report to multiple users at once. |
Email Address | You can insert an external email address so that the report can be sent to external users. Ensure that it is a valid email address. Note: this function depends on your licence options. |
Report | A report can be created to list email addresses for broadcasting. The email addresses don’t have to belong to Yellowfin users. Other columns in this report can be linked to the main report as filters, resulting in a uniquely filtered report sent to each email address. Note: the column that contains the email addresses in this report must be formatted as ‘Email’ to be displayed in the list. To do this: |
3. Once selected, your recipients will appear in the box.
Notes:
Broadcast reports are run for each of the multiple recipients separately, taking into account their access filters, languages or other factors. However, to conserve memory usage and system performance, you can configure it so that each recipient’s report is delivered as soon as it’s generated (instead of waiting for all the recipients’ reports to get done before sending them together). See the configuration to do this here.
- For multiple recipients that have access to the same data, you can set up a ‘carbon copy’ configuration. This allows a single email to be generated and sent to the first user, with the remaining recipients being sent a carbon copy. Note that all recipients will be visible to one another. See the configuration to do this here.
1. Enter text to appear as the subject line.
2. Enter text you wish to use for the body of the email.
3. Select the format you wish the report to be sent as, from the following:
- HTML
- CSV
- DOCX
- XLSX
- Text
- Link to Report
4. If the report is being broadcasted as a document, then an Append Broadcast Date checkbox will appear. Select it to include the current date in the document name.
5. When broadcasting a PDF file, a Secure PDF checkbox will appear. Use this to password-protect your PDF files. You can specify a password yourself, use the one created when exporting the file, or use a default one generated by Yellowfin.
Learn more about this here.
Filters
The options include:
- Current Filter Values
- Default Filter Values
- Bookmarks
Source Filters
If your report uses Source Filters, the Broadcast Report will also be filtered by the Source Filter, as well as whatever filters were defined above. If the report has been sent to an external email address, rather than a defined Yellowfin user, the recipient will inherit the Source Filter from the user who defined the Broadcast.
Note: in order for a user to Broadcast a Source Filter report to recipients not defined in the source filter, they will require the following role permission to be enabled.
Delivery Rule
- Change the Continuous option to Alert
- Click on the Add Alert Delivery Rules
- You will now have the choice of building a rule based on:
- One or more rows must match (e.g. is there a transaction less than $1000) OR
- Aggregate against entire result set (e.g. are the total sales less than $100000)
- Select the field you wish to apply the condition on, click Add Field, and apply your condition. You can add multiple conditions here if required.
- Click Submit to apply your condition(s)
- Your rule will now be displayed on the Broadcast window
- Select the frequency.
Depending on the option selected here, you may be required to provide further details. For example, if Fortnightly is selected, you will be prompted to select either the first or second week of the fortnight to send in, as well as the day of the week. - Apply Advanced Settings (if required)
Sometimes you may find you need to set the Time Zone, and local time for delivery. This can be accomplished by clicking the Advanced Settings link.- Timezone: allows you to set the deliver timezone.
- Limit Schedule Period: allows you to limit the schedule to run only within a set period, rather than forever ongoing.
- Failure Notification: allows you to define an administrator user to be notified if the broadcast schedule fails.
1. Click the Submit button to complete the broadcast setup.
2. You will now see your broadcast listed.
