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

[Former Member]

Hello Bhasakar,

1.Create sysdate object in the universe

2.Create another query in webi and select only sysdate object

3.In the original query drag the Day object in the filter pane and choose the "List of values" from another query.and select the sysdate object from the second query.

So your report always will run for sysdate...

regards,

Naveen D

[Former Member]

Hi Naveen,

Thanks for your useful reply. I have complex calculations like MTD are there in universe itself based on the selection date (prompt date selection). Now I have to change all those calculations based on the system date. We are working on it now. I will let you know for any challenges in doing so.

Regards,

Bhaskar