cancel
Showing results for 
Search instead for 
Did you mean: 

How do you add date (encounter date)for monthly report so I can schedule it for monthly.

Former Member
0 Kudos

How do you add date (encounter date) in the query filter monthly report so I can schedule it for monthly.

Accepted Solutions (0)

Answers (2)

Answers (2)

nscheaffer
Active Contributor

I created Calendar universe be used as a secondary query in Web Intelligence to get dynamic date values for scheduled reports. Here are the technical details on creating that Calendar universe...

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

Noel
kohesco
Active Contributor
0 Kudos

Hi

if you mean how to schedule a report with a dynamic Prompt, the solution depends on your back-end, is it BW or Universe, in BW you can create variables with customer exits if needed or use standard variables. Via a universe you can create something similar. check out

https://archive.sap.com/discussions/thread/3858012

if you google it you will find a lot of doc's concerning that topic.

Grtz

Koen

Former Member
0 Kudos

Thank you for your answer, I do want to schedule it. But in the report itself, in the query filter for the date, want to enter date to look at previous month, so if I schedule my report monthly it schedule to run on Monday the first. Then in the report for the date I would like to have something like month beginning and month ending date.