Skip to Content
avatar image
Former Member

Stop sending webi scheduled blank reports with 2 data sources

We have a schedule which sends out report in excel format to a server.It has 2 datasourses- 2 BEx queries.If one of the query does not return data, schedule sends out blank report even if the other datasource contains data. If the report is run ad-hoc ,it comes back with a pop-up saying ' No data to retrieve in X query '. But we can click on that message box and the data from the other query at least shows up on the report. How to address this issue in the schedude when the report is ran in the background?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 06, 2017 at 05:39 PM

    Hi ,

    Is that schedule configured with Publication ?

    is "One database fetch per user" is enabled for publication ? Check users authorization on queries .

    Regards

    Sateesh B

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 06, 2017 at 04:52 PM

    it seems you are getting data in one query but in report display you don't have matching condition records from both the queries.do you have matching records based on the conditions in both the queries?

    check if any filter applied at report level and for which data is available or not

    Add comment
    10|10000 characters needed characters exceeded