Stop Publication when there is no data

[Former Member]

Hi

I have enterprise recipients with BW authorizations.

I need to send daily report as excel . But I want to stop sending mail ,if " No data to retrieve from query"

How can i achieve this .

Thank You Experts

[CdnConnection]

Linda,

    Currently WebI Publication DO NOT have this functionality. The only way to achieve this would be write a Custom JAVA plugin to NOT deliver when there is no data.

The options is support with a Crystal Publication (see screen-shot), currently the request to add this feature to WebI is under review as an enhancement request.

If you support this functional, please my idea to add this enhancement.

https://ideaplace.brightidea.com/ct/ct_a_view_idea.bix?c=BB5523E4-062F-4420-B35F-0B1F0D4769A9&idea_i...

Regards,

Ajay

[former_member199691]

Here is one option that you can try:

Create a program in which you can use FM RS_VC_GET_QUERY_VIEW_DATA_FLAT or RRW3_GET_QUERY_VIEW_DATA, if it returns any data, trigger the broadcasting process chain else do nothing. Create a PC with this program and schedule it to execute daily.

This approach will work fine as far as you have to send common data to a number of participants.

In case, you have number of users and broadcast is based on authorization and you want to stop the mail only for the user for whom there is no data, you will have to think for a different approach, here is an raw idea (I am not sure how complex and feasible it is):

- Create a report which can be used to find out if there is data for a particular characteristic combination (to check if a authorization combinaiton has data or not).

- Recipient list has to be dynamic.

- This dynamic list is to be preapared based on the output of query created in 1st step and user authorizations.

I hope it helps.

Regards,

Gaurav