tirsdag den 29. december 2015

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/

Ingen kommentarer:

Send en kommentar