on 10-14-2014 6:44 PM
Hi,
I have a webi report which executes for the day prior to today, i.e. if today is 14th oct then report should run for 13th oct. I have used a derived table at universe to achieve this functionality. This derived table gets me the yesterday's date and I am comparing it with a variable in report.
Now this report is to be scheduled from Monday to Friday. But next Monday should have the data for Friday before.
So is there any way to achieve this?
Regards,
Shubham
Try to create a object at universe level which in turn check the condition below.
- If the Day of the Date is from Tuesday to Friday you can use your default formula.
- If it is on monday try to use formula Today-2.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.