You design a SQL Server 2008 Analysis Services (SSAS) solution. The solution has dimensions named Account and Scenario. The Scenario dimension has the keys numbered 1 and 2 for the members named Actual and Budget, respectively. The Account dimension has the key numbered 40 for the member named Income. You create a key performance indicator (KPI) named Net Income that has the following parameters:
KPI Value: ( [Account].[Accounts].&[40], [Scenario].[Scenario].&[1], [Measures].[Amount] ) KPI Goal: ( [Account].[Accounts].&[40], [Scenario].[Scenario].&[2], [Measures].[Amount] ) If the net income is less than 70 percent of the budgeted value, the performance is considered as bad. If the net income is greater than or equal to 90 percent of the budgeted value, the performance is considered as good. You need to calculate the performance at a specific point in time.
What should you do?
A.
Set the Trend expression in the KPI to the following code segment:
Case
When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .90 Then 1
When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) < .90 And
KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .70 Then 0
Else -1
End
B.
Set the Trend expression in the KPI to the following code segment:
Case
When KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) >= .90 Then 1
When KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) < .90 And
KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) >= .70 Then 0
Else -1
End
C.
Set the Status expression in the KPI to the following code segment:
Case
When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .90 Then 1
When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) < .90 And
KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .70 Then 0
Else -1
End
D.
Set the Status expression in the KPI to the following code segment:
Case
When KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) >= .90 Then 1
When KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) < .90 And
KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) >= .70 Then 0
Else -1
End
Explanation:
Tip: "calculate the performance at a specific point in time" = "Status … KpiValue/KpiGoal"