Categories
OBI - get Friday, Saturday, Sunday
Hi,
Struggling with formula to generate report for Friday, Saturday, Sunday weekdays in one go. Any tips?
Answers
-
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...
0 -
Its analysis. Every monday i need it to automatically send me report with last Friday, Saturday and Sunday.
0 -
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.
0 -
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')
0
