Skip to Content
0
Dec 05, 2018 at 04:11 PM

Recurrence Scheduling in Webi 4.2 with Bex variable default values

90 Views Last edit Dec 13, 2018 at 05:53 PM 4 rev

Hi,

I have created Webi report based on Bex query, user wants report output to be delivered to e-mail Inbox, so I have used recurrence scheduling, prompts for the report are Indicator(Values M & S) and Posting date.

For posting date, default Bex variable values are populating but in recurrence scheduling posting date values are not changing everyday

If the report is run today posting date prompt are populating with values 4-Dec-2018 to 5-Dec-2018, If it runs in next day through recurring scheduling posting date are still populating with old values 4-Dec-2018 to 5-Dec-2018, it should run with values 5-Dec-2018 to 6-Dec-2018.

Can anyone help me with solution what needs to be done in Bex query level for posting date prompt.