Skip to Content

Schedule WEBI report - System Date

Hi,

Is there a way to schedule a WEBI report that can receive a system date as an input insted of a manually fixed date?

I need this because  we don't want to be changing the date each month for the WEBI's reports that are scheduled to be sent by e-mail everyday.

Thanks a lot.

Happy  New Year!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jan 05, 2015 at 07:14 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2015 at 10:19 PM

    If you want to go more in depth you could create a Calendar universe as I have described here...

    First day of previous week with a twist

    Then you can create a second query against that Calendar universe and compare the date in your main query to the result from the second Calendar based query.

    Hope that helps,

    Noel

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 01:17 AM

    Veer, Noel, thanks a lot for your answers!

    Our BI solution is not implemented through BO Universe's.

    Instead we are using BW and BO through BICS connection.

    Is there a way we can implement those Magic Dates or Calendar Array in a BEx Query??

    Best!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 04:24 AM

    Hi Sergio,

    1.Please create a customer exit in BW to have current date by default in Bex query variable. So that whenever one executes a BeX Query By default variable value is populated by Current Date/any relative date.

    2. Purge your WebI report and save.

    Result: Whenever report is scheduled/Run by default Desired Date/Current Date is taken.

    Hope it Helps!!

    Regards

    Sheetal Sharma

    Add comment
    10|10000 characters needed characters exceeded