Skip to Content
avatar image
Former Member

Scheduling Reports on Sap BI

I want to run daily reports at 7 am every morning. I can set the date on the prompt.

For Example, the report on the 31/08/17 would be:


Start Date: 30/08/2017 06:00:00

End Date: 31/08/2017 06:00:00

However the next day, I want:

Start date: 31/08/2017 06:00:00
End Date 01/09/2017 06:00:00

Is it possible to schedule a report that gives the data for a set of conditions for the last 24 hours? That gets sent either in BI inbox or in an email ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 01, 2017 at 03:02 PM

    Is this a Web Intelligence report? If so, I have addressed this type of issue by creating a Calendar universe. I can then create a second query that returns the proper relative date and use them in the first query. Here is a blog post that describes how to do that...

    https://blogs.sap.com/2014/02/11/first-day-of-previous-week-with-a-twist/

    If you cannot create this Calendar universe for whatever reason, you are currently unable to achieve your objective. In that case vote for my idea to allow expressions/formulas in the parameter values of scheduled reports.

    Noel

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 01, 2017 at 01:09 AM

    You cannot set different dates each day dynamically. Either you can set a predefined filter or an object used in the filter, last 7 days, 1 day or something like that. Not like one day , you schedule a report with one day gap and another day with 7 days apart.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2017 at 08:51 AM

    You would need some assistance from your backend development team. They can provide you with time slices (using SAP exit variables) or restricted key figures. You would need to leave the date prompt empty - and the backend code would make sure that if date prompt is empty it automatically picks up last 24 hrs of data.

    Then setup your schedule. it would work

    Add comment
    10|10000 characters needed characters exceeded