How to run webi report automatically with the current date/system date in webi report

[Former Member]

Hi Friends,

I have a webi report which has a date prompt now. Based on the selection that user makes while running a report, he will get the related data for that particular date selection. Now I want to make that date prompt automated that is the report should run automatically based on the system date daily on scheduling.

I want it to run current day automatically without have to go in and pick the date in webi report. I will be scheduling the webi report. Can you please let me know how to achieve this functionality of running a webi report automatically with a system date.

Please let me know if I couldn't make you understand so that I will write with an example.

Waiting for your valuable solutions.

Thanks in advance.

Regards,

Bhaskar

[Former Member · Accepted solution]

Hi Basker

Creat a Object at universe level with "Sysdate"

use the object in web report

now report will run on current date and schedule the report as per your requirement

Regards,

Mahi

[Former Member · Accepted solution]

Hi Mahi,

Thanks for your prompt reply. Let me work on this and will let you know for concerns.

Thanks again.

Regards,

Bhaskar