Skip to Content
0

Mail should not triggered if there is no data in webi

Nov 04, 2016 at 04:28 AM

159

avatar image

Hi,

We schedule some webi reports and send out the reports by email. Sometimes the reports do not have data return. Are there any methods to generate emails that only the reports contain data?

Thanks

Harika

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Kuldeep Ghosh Nov 04, 2016 at 09:56 AM
0

This was possible for Crystal Reports, but unfortunately Webi doesn't provide this functionality. I came across this idea and looks like SAP has implemented this Idea and has been provided on BO 4.2 Sp3. Have a look at this

Delivery Rules Function for WebI Publications (D8514)

The solution is provided in this blog, but unfortunately the link is not working.

Hope sap would fix the link for the blog soon.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for the response, but is there any option or logic to solve this issue in webi or CMC

Please help on this, If you know.

Thanks

Harika

0
AMIT KUMAR
Nov 08, 2016 at 04:24 PM
0

Other option you can try with event based scheduling.From the database generate the file only when data is available and with event schduling report will run only when Bo will get the file.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

can you tell me how to create event and where we have to create this event...

can you tell me step by step procedure clearly... we are new to this concept

0

I guess to create Database generate File we need to use exact same Query as that of Report. If report is having some Filters (Query or Report) then checking only DB level Data dont work as expected.

Then you need have Exact same Query as that of you using at BO Report level including Query level Filters.

0
AMIT KUMAR
Nov 09, 2016 at 09:26 AM
0
Share
10 |10000 characters needed characters left characters exceeded
Sushil Padhye Nov 09, 2016 at 10:05 AM
0

Hello Harika,

One way of Impementing this (If you don't have any Report Level Filter) is creating one more Query at Data Provider.

Steps:

1) Create on Measure at Backend with Formula as (1/Count(dimABC)) - dimABC is any dimension.

2) Create One more Query at Data Provier and put only measure created at step 1.

3) Add Query Filter in this New Query as "dimABC" InList from Actual Data Provider (which may cause No Data).

4) Dont use this New Query anywhere in Report.

How it will work:

1) If your actual Query is not having any Data then Count(dimABC) will come as 0.

2) So new Query will fail with "#DIV" error and Schedule will fail.

3) When you have any Data Count(dimABC) will return Number and New Query will be running successful as so as Schedule.

Please check and let me know if it works.

Regards,

Sushil Padhye

Share
10 |10000 characters needed characters left characters exceeded
Sai Prasad Nov 28, 2016 at 10:20 PM
0

Hi Harika,

Yes we can achieve it in BI 4.2.Please refer the publication delivery rules section on below link.

https://archive.sap.com/documents/docs/DOC-74364

Thanks,

Durga

Show 1 Share
10 |10000 characters needed characters left characters exceeded

sorry for the late reply, we already refered that document link but currently we are working in BOBI 4.1 SP5.

Please any other suggestions.

Thanks,

Harika

0