We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

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

Received Response
19
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!