Overview
Broadcasting allows you to send a report to one or more users, based on a defined schedule and set of rules. A personal broadcast is exactly the same as a standard broadcast, with the exception of defining who it is sent to. A personal broadcast is only ever sent to the person that defined the broadcast.
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 option.
4. The Broadcast window will open, providing you with the following options:
Recipients
A Broadcast email can only be sent if recipients have been defined. One or more recipients can be selected for a Broadcast.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. 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.
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
- DOCX
- XLSX
- Link to Report
Filters
If your report contains filters you will have the option to select which of these are applied to the Broadcast Report.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
A Delivery Rule is used for exception reporting. If you wish to send a report only if it meets certain criteria (for example: Revenue is less than 100,000) then you will need to add a 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.
