About
To address the issue of delayed email reception for Data IQ® subscriptions set for a specific time of day, you can follow these steps and consider the provided solutions:
Steps
Understand the Delay: When the scheduled subscription time is reached, Tableau must generate each dashboard/report individually to create an image file that is emailed to the recipients. For example, if 10 people have a subscription for a dashboard that normally takes 60 seconds to load, it will take approximately 600 seconds (10 minutes) to generate the subscription. This process is combined with all other subscriptions scheduled around the same time.
Solutions
Minimize the Number of Subscribers:
Ensure that only the required persons are subscribed to a report. This can help reduce the overall load and generation time.
Subscribe to Individual Sheets:
If a dashboard contains multiple individual reports, consider subscribing to those specific sheets of the workbook that are needed, rather than the entire dashboard. This can significantly reduce the generation time if only parts of the dashboard are required.
Utilize Active Directory Groups:
Use Active Directory groups to send subscriptions. This approach allows the subscription to be generated only once for all members of the email group, rather than individually for each recipient. This can greatly reduce the overall time required to generate and send the subscriptions.
Additional Considerations
Schedule Staggering: If possible, stagger the subscription schedules so that not all reports are generated at the same time. This can help distribute the load and reduce delays.
Optimize Dashboards: Ensure that dashboards are optimized for performance. This includes minimizing complex calculations, reducing data extract size, and ensuring efficient queries.
Subscription Prioritization: If certain reports are more critical, prioritize their generation and scheduling over less critical ones.
By implementing these solutions, you can help mitigate the delay in receiving subscription emails and ensure a more efficient reporting process.