topic Re: Alert Based Email in SAS Visual Analytics

Alert Based Email

TejaSurapaneni — Wed, 10 Jun 2015 13:26:14 GMT

Hi All,

Present I am working on VA 7.1, is there any way to send percent based emails, let us suppose ..

I have data like this

E-Name Target Actual Achvt% email id

X 200 200 100% x@abc.com

Y 100 23 23% y@abc.com

Z 200 100 50% z@abc.com

is there any way to send alert or Email who's achvt is below 60%.

X acvt is 100% so i want to send email or alert except X.

Is there anyway to achieve this...

Thanks.

Teja Surapaneni

Re: Alert Based Email

Meredith_SAS — Tue, 23 Jun 2015 17:24:42 GMT

Hi Teja Surapaneni,

In Visual Analytics, click on Report Designer. I will be using the data you have provided above as an example. Therefore, in Designer I would create a list table with E-Name, Target, Actual, Achvt%, and Email ID as column headers. Then, on the right side there are a list of tabs including Properties, Styles, and Display Rules. Click on the drop down arrow that will state List of Tabs when you highlight over it. Here, click on Alerts, then click on new alert. In the Expression tab, customize your alert to have the Column as Achvt%, Operator as <, and Value as 60. In the Subscription and Notification tab, click the plus sign to add registered users that would receive the alerts if Achvt% for any row is below sixty percent. However, you can only send the alert to a registered user in the system, in which their email will be linked to their name. Therefore, when X and Y are below sixty percent, any subscribed user will be notified. In addition, you can control how many notifications are to be sent to the subscribers per minute, hour, and day. Please let me know if you have any more questions!

Thank you,

Meredith Bailey

Re: Alert Based Email

TejaSurapaneni — Thu, 25 Jun 2015 11:44:21 GMT

Hello Bailey,

Thanks for response,

E-Name Target Actual Achvt% email id

X 200 200 100% x@abc.com

Y 100 23 23% y@abc.com

Z 200 100 70% z@abc.com

You are saying that if any employee is doing below 60%, The mail(alert) will sent to all registered employees, But i want to sent only that particular empl. who is doing below 60%. from the above example i want to send alert only for Y and it should be automated.

Thanks,

Teja Surapaneni.

Re: Alert Based Email

Meredith_SAS — Thu, 25 Jun 2015 17:09:53 GMT

Hi Teja Surapaneni,

Yes, if one employee in particular is below sixty percent, the alert will be sent to all registered users who are subscribed to the alerts. Unfortunately, there is no way to only send an alert to that specific employee who is below sixty percent.

Thank you,

Meredith Bailey

Re: Alert Based Email

DonJanssen — Fri, 15 Jun 2018 12:24:07 GMT

Hi,

I'd guess one could restrict the access to the table in such a way, that each user only sees his/her own row(s).

And then if in the row with the name of person A in it, the specific value occurs, person A gets a message, but not all the others.

Wouldn't that be the VA behavior one can expect?

Don