Problem in creating KPI...

hi,

facing problem in creating kpi. kpi details follows,

associated measure group:
fact target

value expression:
[measures].[target %]

goal expression:

case  when  ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[low])  ,  ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[voice])  ,  ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) )  0.75  when  ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[low])  ,  ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[non-voice])  ,  ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) )  0.75  when  ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[medium])  ,  ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[voice])  ,  ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) ) 0.85  when  ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[medium])  ,  ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[non-voice])  ,  ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) ) 0.85  else 0.995                          end

status expression:

case     when kpivalue( "kpi" ) /           kpigoal ( "kpi" ) >= .99     1     when kpivalue( "kpi" ) /           kpigoal ( "kpi" ) <  .90          ,           kpivalue( "kpi" ) /           kpigoal ( "kpi" ) >= .80     0     else -1 end 

my target dependent on 3 dimensions namely priority, service , vertical. “value” , “status” expression fields working fine. but, “goal” expression field not working me. showing me “else” part value. “value” changing accoring dimension member selection.

please, me overcome issue. how want rearrange above goal expression desired result?

regards,

sujeev

hi all,

have solved issue. in "value expression" have use "achieved %" , in goal have use "target %".  have made following changes in value , goal expression.

associated measure group:
fact target

value expression:
[measures].[achieved %]

goal expression:

case when  ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[low])  ,  ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[voice])  ,  ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) )  [measures].[target %]  when  ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[low])  ,  ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[non-voice])  ,  ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) )  [measures].[target %]  when  ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[medium])  ,  ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[voice])  ,  ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) ) [measures].[target %]  when  ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[medium])  ,  ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[non-voice])  ,  ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) ) [measures].[target %]  else [measures].[target %]  end

status expression:

case     when kpivalue( "kpi" ) /           kpigoal ( "kpi" ) >= .99     1     when kpivalue( "kpi" ) /           kpigoal ( "kpi" ) <  .90          ,           kpivalue( "kpi" ) /           kpigoal ( "kpi" ) >= .80     0     else -1 end

now working fine.

regards,
sujeev

SQL Server  >  SQL Server Analysis Services