Skip to Content
avatar image
Former Member

Mail should not triggered if there is no data in webi

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 04, 2016 at 09:56 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Nov 08, 2016 at 04:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Nov 09, 2016 at 09:26 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 09, 2016 at 10:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2016 at 10:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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