A BI Report data model have two data sets with one data sets not returning data

Question

I have a client requirement, a BI report having two data seta when one data set does not return data. The report should not generate output for one data set and send email with one data set output to the.

Please help I need it urgent I am in middle of UAT.

Bhaskar Konar · Answer

Hi @SayanDutta,

Please find below a worked example.

Using Schedule Trigger in Oracle Fusion Cloud Application A Worked Example

Hope this help.

Thank you.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/25106/a-bi-report-data-model-have-two-data-sets-with-one-data-sets-not-returning-data

Hi @SayanDutta,

You can do this using Schedule Trigger functionality.

Please take a look into the following note (especially point5) which might be useful.

https://docs.oracle.com/cd/F18701_01/html/rpm_82_userguide/GUID-FB0281F1-A9E3-4FA6-AA16-BE0A9C02460E.htm

Hope this help.

Thank you.

SayanDutta · Answer

When one data set does not return data the report is generating output with one data set results and sending email. I want if one data set does not have data dont generate the output and send email.