Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 11, 2017 at 03:29 PM

    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
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2017 at 01:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.