on 10-10-2017 10:30 PM
How do you add date (encounter date) in the query filter monthly report so I can schedule it for monthly.
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/
NoelYou must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.