2. Set up a job (SSIS) to check out Analysis Services tables and shoot email notifications

[jesusitd]

Set up a cronjob on SSIS to shoot email notifications on Poorly performing ads off of SSAS analyzed Ads tables.

Reading material with optional CC to @nmusco :

• https://docs.microsoft.com/en-us/sql/analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/querying-a-tabular-model?view=sql-server-2017
• https://www.sqlbi.com/articles/execute-dax-queries-through-ole-db-and-adomd-net/
• https://www.fourmoo.com/2014/04/03/ssis-using-sql-server-analysis-services-ssas-mdx-query-into-variable-in-execute-sql-task/

[jesusitd]

This will be a next step.

[jesusitd]

Being done by Upwork's Andrey

[jesusitd]

Waiting on Ray to provide AzureAS and Azure Function Apps logins to continue (migrated to cloud)

CC @fedegarza @richarditd

[jesusitd]

Completed successfully.

Service running on Azure with Analysis Services and Function Apps.