Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Stop BI publisher report if no row is returned in data model SQL query
Summary
Stop BI publisher report if no row is returned in data model SQL queryContent
Hi All,
I am new to BI Publisher reporting and want to avoid blank report if no rows selected in the query. Please let me know how I can stop.
E.g I am using f/w query:
select target_type,count(*) CNT from mgmt$target where broken_str is not null;
In this, if there is no such target with broken state, a blank report is sent to the confirmed email. I want to avoid this.
Thanks,
Shyam
0