cancel
Showing results for 
Search instead for 
Did you mean: 

Scheduling for Friday data on Monday

shubham_chawla
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182521
Active Contributor
0 Kudos

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.

shubham_chawla
Explorer
0 Kudos

HI Manikandan,

Firstly, thank you so much for your response.

Actually I was also thinking the same, but I can't design a MYSQL code, I could do that in PL/SQL but my DB is of MYSQL. So could you help with any such code?

Regards,

Shubham Chawla

shubham_chawla
Explorer
0 Kudos

I am sorry it microsoft sql