Dynamic distribution lets you distribute publications automatically to different users based on the currently selected slicer value. This powerful feature allows you to set a schedule whereby the publication will be sent to a list of addresses. The addresses are derived from a distribution list or via the data-driven security specified in the data model. This allows you to ensure that each recipient receives only the information that is relevant to them.
For instance, add a Country slicer to the publication, then set the email distribution to send publications according to the country. This way you can generate a separate copy of the report for each country, and send each copy to the relevant recipient; send the USA report to the USA marketing team, while sending the EMEA report to the EMEA marketing team.
Rendered publications may be dynamically distributed to the internal Pyramid portal (bulletin board), via email, via SMS and WhatsApp or to Webhooks (Teams and Slack) - depending on configuration.
Sending as an attachment is available only with the Extended Report Bursting License.
Configuring a Distribution List
There are two ways to configure a dynamic list:
- File mapping allows you to import an existing list of users or emails.
- Data mapping enables you to build a dynamic list in the PQL editor.
Set Dynamic Distribution
Publications may be distributed to the bulletin board or via email using a static or dynamic list of either roles or users. Distribution to the bulletin board is a good way to share publications with colleagues who have access to Pyramid. Email distribution enables you to reach users who don't have access to Pyramid.
Note: When configuring a dynamic distribution, it's important to set the correct preferences in both the Selections and Distribution panels.
Slicer Selections
From the Selections section in the Schedule panel, choose Multiple, then select the slicer elements that should be used when rendering the report and looking up the distribution list. If your publication contains multiple slicers, you can choose "slice combinations" that each copy of the report should be filtered and sent by.
Use Dynamic List
The dynamic list option is shown in the Distribution panel if the publication contains a slicer.
From the Distribution section in the Schedule panel, select the dynamic list option to import a list of roles or users, and dynamically distribute the publication to recipients according to given slicer elements. The dynamic list may be imported, or it can be configured in the PQL Editor.
Publications may be dynamically distributed to the bulletin board or via email. Distribution to the bulletin board is a good way to share publications with colleagues who have access to Pyramid. Email distribution enables you to reach users who don't have access to Pyramid.