Published Report Schedule - showing message if attachment has nothing

slgott

Summary

If the published report attachment has no data, can we put that in the body of the message?

Content

Hello,

For a personal BIP report schedule, if the attachment has no data on it, is there a way to call that out in the body of the email message to the user? We find that users are opening reports that have no data unnecessarily. Some days the report will have data, sometimes it might not and that could be valid. If there is a way to show the user that they don't need to open the attachment because it doesn't contain data, that would be great. Any thoughts? 

Thanks,

Stephanie

User_9UROC

Does anyone have a solution to this

Gaurav Bharadwaj-Oracle

Hi @User_9UROC ,
I understand you are asking a question regarding BI Reports that send out an Email.

There is no way to intimate the user to not open the email/attachment. However if you want to stop sending out emails when there is no data, you can review this document and implement Schedule Trigger :

Fusion BI Publisher - Stop BI From Delivering a Report That is Empty (Doc ID 2226955.1)

Besides this if you still want a solution where the user gets the email and is intimated to not open it then you will need to log an IDEA in Idea Labs so our Product Management can review the same and if feasible implement it in one of the upcoming releases.

Idea Labs can be found Here : https://cloudcustomerconnect.oracle.com/pages/home
Before creating an Idea, it is recommended to go through the Guidelines : https://cloudcustomerconnect.oracle.com/pages/35fcc3b659

After logging in to the customer connect portal, please click on Idea menu and select the appropriate product.On the following page you should be able to see a button "Submit Your Idea" please use that to request an Enhancement.

If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

Regards,

Gaurav

Anusha Bhat-Oracle

Please use Schedule Trigger option in BIP to avoid sending mails if the report has no output. Query format for Event Trigger: SELECT 'TRUE' FROM (Query used in data model) tbl. Select this event trigger while scheduling the report.

Note: Please make sure to remove any comments event trigger query.

Bhaskar Konar

Anusha Bhat-Oracle

Feb 25, 2025

Please use Schedule Trigger option in BIP to avoid sending mails if the report has no output. Query format for Event Trigger: SELECT 'TRUE' FROM (Query used in data model) tbl. Select this event trigger while scheduling the report.

Note: Please make sure to remove any comments event trigger query.

Very helpful information.

Thank you very much @Anusha Bhat-Oracle!