Stopping blank reports from publications in SAP Analytics Cloud

[Scott13]

Hi, we have a story which shows our sellers quotes for the day, we have this set up using data access controls and a publication in burst mode. Is there anyway to only send a report when there is data for them? Currently everyone on the seller team receives a report even if blank.
Any advice appreciated, thank you.

[GiriRaaj]

Hi,

Unfortunately there is no out-of the box solution to this scenario. but there is a workarounds you can apply.

Workaround :

1. Create a Restricted Measure: Create a restricted measure that filters only when COUNT([QuoteID]) > 0.
2. Set Story Filter: Apply a filter at the story level that only includes users where the count is greater than 0.
3. Publication Will Skip Empty Reports: Since SAC Publications only distribute content based on the existing filter,sellers with no quotes will be excluded from the burst.

Thanks with regards

Giri