Email Notification on Business Indicator e.g. Sales Drop by 3% in OAC

User566089-Oracle

Hello team,

Wanted to know if we have a way to achieve below functionality with OAC

• Email Notification on Business Indicator e.g. Sales Drop by 3% in OAC Visualization i.e. Tiles or any other visualization

Brendan T

Have a look at using OAS Agents to trigger an email when a specific even occurs. Heres the link to the documentation on this https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/automate-business-processes-agents.html#GUID-58082547-B607-4AC4-883D-DDF904F78E3B

Gianni Ceresa

What Brendan said.

"Classic" agents have a condition that allow the agent to continue execution or stop it. Just do not abuse the schedule: don't schedule an agent to run every 5 minutes with a condition on the sales drop % if you load your source data only once every hour or once per day.

Even if the agent doesn't send anything, it is still executed and will check the condition all the time, schedule it correctly based on the frequency of your data load.

Also make sure to keep the condition as simple as possible: no need for the condition to retrieve 10k rows over 20 columns, it just need to return something or nothing (it's a condition), therefore build it with a "minimum effort" in mind.

Benjamin Arnulf-Oracle

There is an idea in the idea lab about this feature:

https://community.oracle.com/products/oracleanalytics/discussion/21408/add-conditional-triggers-for-dv-email-scheduler

also that one:

https://community.oracle.com/products/oracleanalytics/discussion/23691/alerts-email-notifications