Skip to Content
0

Scheduling Reports on Sap BI

Aug 31, 2017 at 09:42 PM

99

avatar image
Former Member

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 ?

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

3 Answers

Noel Scheaffer Sep 01, 2017 at 03:02 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jawahar Konduru Sep 01, 2017 at 01:09 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 01, 2017 at 08:51 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded