cancel
Showing results for 
Search instead for 
Did you mean: 

Schedule WEBI report - System Date

sergiordz
Explorer
0 Kudos

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!

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member211423
Active Participant
0 Kudos

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

sergiordz
Explorer
0 Kudos

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!

nscheaffer
Active Contributor
0 Kudos

We don't use BEx so I cannot speak to that.

Noel

Former Member
0 Kudos

Hi Sergio,

Refer :

Regards,

Veer S.

nscheaffer
Active Contributor
0 Kudos

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

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

Former Member
0 Kudos