You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
25
Views
3
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 3 comments

Summary

Stop BI publisher report if no row is returned in data model SQL query

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!