Summary

BI Pub Bursting (for no result key need to send a custom message)

Content

Hi,

I am using a bursting job using a bursting delivery table and bursting definition sql. It is working fantastic with Keys those have data it is creating an excel and sending it out as expected via email. If a key is null it doesn't produce the file which is normal. However, now I am posed with a challenge where the key is null for the day and no files generated, for those I need to send the delivery without the file attached but add a customized message in the email body. How would i tackle that? 

My email body message is also stored in the bursting delivery table.

Thanks in advance!!

Bursting sql:

Select 

t.employee_id as Key,

t.template as Template,

'en-US' as Locale,

t.output_format as Output_format,

'true' as SAVE_OUTPUT,

'EMAIL' as DEL_CHANNEL,

t.employee_id||'-'|| to_char (Current_Date, 'ddMONyyyy') as OUTPUT_NAME,

t.email as Parameter1,

t.cc as Parameter2,

t.reply_to as Parameter3,

to_char (Current_Date, 'ddMONyyyy') as Parameter4,

  t.message_body as Parameter5,

  'true' as Parameter6,

  t.reply_to as Parameter7,

  NULL as Parameter8

From

t_burst_delivery t

Where

t.active = 'Y'

and t.REPORT_NAME = 'burst_cmpl'