Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Agent should not trigger on regional holidays in OBIEE 12c

Hi All,
I have a agent triggering from Monday To Friday. Report containing only Monday to Friday data, My requirement is, If holiday happen between Monday to Friday that records should not appear in the report. and having Calendar_Holiday table. This table having list of holidays.
Please suggest how to achieve this requirement.
thanks in advance
Answers
-
Well you just have to model it into your time dimension and filter on it. You sound like you have that already in your data so if it's tied in the you can just put it as a filter like HOLIDAY=FALSE
0 -
Unclear:
- want the schedule not to run on a holiday?, OR
- just don't want to see holiday rows in any report run from this schedule?, OR
- both 1 & 2, OR
- something different than 1 and/or 2
0 -
If you look at agents you have a condition screen where you can set a condition, and if condition not met then the agent abort (in a way, it doesn't execute and send out anything).
So do what Christian said and set it as condition for your agent, and set your agent to run daily: done!
0