January 20, 2009 at 6:45 am
Does anyone know if you can specify KPI's with more than just the -1, 0 and 1.
I would like to create a KPI with a greater variation than 3 options, to better reflect a KPI's performance.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
March 18, 2009 at 10:09 am
You are not limited to -1,0, and +1. Actually the status value can be any decimal value from -1 to +1. For example (as shown in the tutorial of MS's SQL Server 2005 documentation), the Status Expression could contain the following:
Case
When [Measures].[Reseller Sales-Sales Amount] >
[Measures].[Sales Amount Quota]
Then 1
When [Measures].[Reseller Sales-Sales Amount] >=
.90 * ( [Measures].[Sales Amount Quota] )
Then .5
When [Measures].[Reseller Sales-Sales Amount] >=
.80 * ( [Measures].[Sales Amount Quota] )
Then 0
When [Measures].[Reseller Sales-Sales Amount] >=
.70 * ( [Measures].[Sales Amount Quota] )
Then -.5
Else -1
End
Hopefully I understood your question and this helps,
Norm
March 18, 2009 at 10:22 am
Yes thanks.
I couldn't find any examples other than -1 0 and 1. Thats good to know though- thanks.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply