Hi,
Struggling with formula to generate report for Friday, Saturday, Sunday weekdays in one go. Any tips?
What do you mean?
Is a "report" a BI Publisher report or an analysis? What you mean by "generate"?
If you add a filter and pick the 3 days of the week, it should do what you need...
Its analysis. Every monday i need it to automatically send me report with last Friday, Saturday and Sunday.
Create an analysis with the filter on the day of the week (there is a function returning that from a date), schedule it with an agent to be executed and delivered on Monday.
Adding to Gianni's answer:
DayName("SomeDimension"."ThisIsADateField")
Yields Mon, Tue, Wed,.... depending on your locale settings. Then put the filter Gianni mentioned to
XYZ in ('Fri','Sat','Sun')
