Clearly no one wants to open a blank report. It’s a bit irksome to open a report and see no data. But sometimes scheduled reports may send a blank report with no data to your customer. So why generate a blank report?
I use WebI to generate basic to complex reports. Web Intelligence (WebI) is part of SAP Business Objects product suite and is used for analytical and ad hoc reporting to meet an organization’s business requirements.
When there is no data for the defined conditions, by default WebI generates the report, a blank report with just headings, and sends it to the emails configured.
To avoid this, SAP BO has a feature to define delivery rules to stop generating/sending blank report to customers. But this feature is available only from SAP BO 4.2 SP where rule can be set to not send the publication if scheduled content has no data.
In older versions, this rule is not possible as this feature is not available as shown in the below figure.
But it can be achieved in the following way.
First, A separate SQL query “SELECT case when count (*) > certain amount then (1/0) end” must be written. Where if the count of objects returns no data, then (1/0) cause an error. If there is no data in the query, then the reports will fail depending on the value.
Create an event in Central Management Console (CMC) for the scheduled report and select the event type Success. While publication select the event created for the WebI report.
And that’s how we get rid of the scheduled report when the report is empty.
How to Avoid a Data Breach Government agencies are becoming prime targets for cyber attackers, they hold data for ransom. Whatever the rationale of the cyber attackers, it is imperative that government agencies need to pull up their socks to understand the gravity of...
Sennovate Insights: Gartner Magic Quadrant in Access Management 2019 Technology providers are present worldwide, but to know who is the best among the vendors is a challenging task for analysts, and for organizations to choose, as each vendor offering will have some...
Real ID-Compliant – A Must for all ResidentsStarting October 1, 2020, every State and Territory Resident will need to present a REAL ID-compliant license/ID or another acceptable form of identification (like a passport or passport card) for boarding commercial...
Stay Up to Date With The Latest News & Updates
Join Our Newsletter
Unleash more of your potential with weekly updates, tailored for your team.