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.
Role of Security assessment in Mergers and acquisitions (M&A)Due diligence Review (DDR) is critically important component in the M&A process, be it financial numbers or legal/ regulatory obligations with big monetary stakes. Amidst all these, cyber security...
Fintech Security warnings – being well preparedWith rapid increase in adoption of Fintech, come increased security threats. Newer technologies like Block chain, Artificial Intelligence (AI) in the Financial services industry is not only reducing the manual work...
Rise & Rise of API’sApplication programming interface (API) being the hidden backbone of applications. Developers rely on these API’s to communicate with another software programs or applications. According to a survey findings indicate 69% of organizations...
Stay Up to Date With The Latest News & Updates
Join Our Newsletter
Unleash more of your potential with weekly updates, tailored for your team.