Extending and Customizing Cubes - SQL Server Analysis Services 2012 Cube Development - page 149

When
[Date].[Calendar].CurrentMember.Level Is
[Date].[Calendar].[Calendar Quarter]
Then .05
When
[Date].[Calendar].CurrentMember.Level Is
[Date].[Calendar].[Month]
Then .025
Else "N/A"
End
6. Next choose the thermometer as the Status Indicator , icon and define the
status expression as follows:
Case
When KpiValue( "Internet Order
Growth" ) >=
KpiGoal ( "Internet Order
Growth" )
Then 1
When KpiValue( "Internet Order
Growth" ) >=
KpiGoal ( "Internet Order
Growth" ) * .80
And
KpiValue( "Internet Order
Growth" ) <
KpiGoal ( "Internet Order
Growth" )
Then 0
Else -1
End
7. Lastly choose standard arrow as the Trend Indicator , and enter the following
MDX query for trend expression:
Case
When IsEmpty(