Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Agent should not trigger on regional holidays in OBIEE 12c

Received Response
1
Views
3
Comments
s234
s234 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Unclear:

    1. want the schedule not to run on a holiday?, OR
    2. just don't want to see holiday rows in any report run from this schedule?, OR
    3. both 1 & 2, OR
    4. something different than 1 and/or 2
  • Gianni Ceresa
    Gianni Ceresa Mod

    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!