on 2014 May 07 9:48 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.