OBIEE 12c Agent — Oracle Analytics

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

OBIEE 12c Agent

Received Response
82
Views
6
Comments
Vijay Nathan
Vijay Nathan Rank 1 - Community Starter
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

Hi Everyone,

Is possible to set Month End Agents in OBIEE 12c. Which means On every month end I would like to trigger an auto-mail to users. Is this possible in OBIEE 12c Agent ?

When I select date and All months in Agents, it shows validation message.

Thanks in advance.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    You get a message because if you select 31 and all the months there are many months where the 31 doesn't exist (if you select 28 you don't get the warning anymore as all the months have the 28).

    So there isn't a "checkbox" way to set an agent to run at the end of every month ...

    Do you really want to run it the last day of the month or do you want to send out the data of the month you just closed? Maybe running the 1st day of the month is an acceptable alternative?

    Or you can setup your agent to run daily but adding a condition, the condition would be really simple and it check if CURRENT_DATE is the last day of the month (of course your agent will try to run 353 times being stopped by the conditions and only 12 times something will be done, but that's the price to pay ...).

    You can of course make 3 agents schedules for the 31, 30 and 28 based on the months (but remember sometime February has 29, so ... still doesn't work by itself )

  • Rampradeep Pakalapati
    Rampradeep Pakalapati Rank 3 - Community Apprentice

    HI,

    Use a condition while creating the agent, use condition as rowcount >0 . Create an Analysis with below code, which gives you Day number in the month by adding 1 day to the current date. Set filter on the same as less than 2, which means you will get a record only when your output number is 1, which in turn means the current date value is the last day of the current month.

    DAYOFMONTH(TIMESTAMPADD(SQL_TSI_DAY,1,CURRENT_DATE))

    Thanks,

    Rampradeep

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    @Rampradeep Pakalapati , I'm curious what is the difference between your answer and @Gianni Ceresa 's one.

  • Rampradeep Pakalapati
    Rampradeep Pakalapati Rank 3 - Community Apprentice

    I haven't read that completely before, I have done  a similar setup earlier this year, so gave the code that i used straight away.Only after your message I noticed that he had referred to this approach.

  • Rampradeep Pakalapati
    Rampradeep Pakalapati Rank 3 - Community Apprentice

    Hi Vijay,

    If you are on windows you can achieve this with some effort, sashinvoke.exe is used to trigger the Agents from command line. So if you can manage to develop a VB script that will execute on last day of every month, which in turn invokes the job to run it is achievable.

    Thanks,

    Rampradeep

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    So found what you were looking for? (knowing there isn't an ootb checkbox for that)

    If yes you can maybe close the thread?