Is it possible to control email notifications in the report scheduler based on data model results?
When scheduling a BI Publisher Report, I only want to send an email notification to designated users when the report returns data. Is this possible?
I created a "troubleshooting" report and need to schedule it. However, I only want Oracle to send an email notification to designated users when the report returns data. When the report does NOT return data, it means that there are not any data issues that need to be resolved, so I do not want any users to be emailed. My data model is based on a very long SQL query that links numerous tables.. I thought that I could create a trigger, but it does not look like I can create a trigger based on