KPI

https://www.youtube.com/watch?v=ymPDKnmreDI
https://www.youtube.com/watch?v=dFSktRibMBA

KPI Name:

"OTD Aggregation"

Value expression to count only those with "on-Time" in column: "OTD Text"

([Milestone].[OTD Text].&[On-Time], [Measures].[Vw Milestone Count])

Status Expression:

Case
    When Isempty(KPIGoal("OTD Aggregation")) Then Null
    When KPIValue("OTD Aggregation") > KPIGoal("OTD Aggregation") Then 1
    When KPIValue("OTD Aggregation") = KPIGoal("OTD Aggregation") Then 0
Else -1
End


http://pragmaticworks.com/Training/Resources/Cheat-Sheets/MDX-Expression-Cheat-Sheet
https://mikedavissql.com/2014/01/06/ssas-dynamic-kpi-from-a-table/

Automate SSAS Cube using SQL Server Agent

Browse the analysis server using SQL server management studio.
Right Click on your Database on the analysis server, and click process.
On the dialog window, cllick the 'Script' Button. Copy this script (in the window below) to the clipboard.

Connect to the relation database (SQL server), and make a New Job and task in the SQL Server Agent.
Create a step in the task that is of the type Analysis Service Command. Paste the script to the window, and fill in the url to the analysis server (AS), and the name of the database in AS.


https://www.youtube.com/watch?v=7UlrhCAA_48

SQL Server Agent to automate SSIS Package

set up a task in the sql server agent in sql management studio for the database, and then under create a new task to and setup a task to run SSIS package

https://msdn.microsoft.com/en-us/library/ms141701.aspx

From SQL server to SQL Server Analysis Service Multidimentional Cube

Article is a bit old, but the fundamentals still apply for SQL Server Data Tools 2012

https://www.simple-talk.com/sql/reporting-services/five-basic-steps-for-implementing-an-analysis-services-database/