Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 185 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 63 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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