Is there a way to specifiy more than 3 levels (indicators) for KPI Status
and Trends.

For example:

Sure - these should be normalized values between -1 and 1, but there can
be more than 3 discrete values. For example, the standard "Gauge" and
"Reversed gauge" status indicators can show 5 distinct values: -1, -0.5,
0, 0.5 and 1.

To try this in Adventure Works, change the Status expression of the
"Expense to Revenue Ratio" KPI, which has a "Reversed gauge" indicator,
as below. Now, if you browse this KPI by Calendar Quarter, from 1Q2002
thru 1Q2003, you should see 5 different positions of the gauge:

When KpiGoal( "Expense to Revenue Ratio" ) /
KpiValue ( "Expense to Revenue Ratio" ) >= 1
Then 1
When KpiGoal( "Expense to Revenue Ratio" ) /
KpiValue ( "Expense to Revenue Ratio" ) >= 0.926
Then 0.5
When KpiGoal( "Expense to Revenue Ratio" ) /
KpiValue ( "Expense to Revenue Ratio" ) >= 0.862
Then 0
When KpiGoal( "Expense to Revenue Ratio" ) /
KpiValue ( "Expense to Revenue Ratio" ) >= 0.833
Then -0.5
Else -1
End

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***