Skip to Content
0

Automate WEBI Reports

Sep 21, 2017 at 03:03 PM

38

avatar image
Former Member

Hi,

I have a requirement to automate the existing reports on every Monday with a 6 weeks rolling time frame. Currently, I schedule these reports and send it to myself in my inbox by changing prompts in the scheduler. But I want to eliminate that step as well. Is there any way, I can get a rolling 6 weeks time frame in the prompt automated and output it in Excel?

Any help will be appreciated.

Thanks,

10 |10000 characters needed characters left characters exceeded

what is your backend database?check attached link.You will get the idea how to go back 6weeks from current date in universe.

https://blogs.sap.com/2016/03/10/custom-predefined-date-range-filters-wtdmtdqtdytd-in-bo/

0
Former Member

Hi Amit, Thanks for responding. I believe its SQL Server but I am not "allowed" or rather I do not have access to that. I am a business user and I need to make this work on the front end. Thanks.

0

It is not possible through webi report.you need to define the predefined filter at universe level.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers