KPIStatus (MDX)KPIStatus (MDX)

返回表示指定关键绩效指标 (KPI) 的状态部分的规范化值。Returns a normalized value that represents the status portion of the specified Key Performance Indicator (KPI).

语法Syntax

  
KPIStatus(KPI_Name)  

参数Arguments

KPI_NameKPI_Name
指定 KPI 名称的有效字符串表达式。A valid string expression that specifies the name of the KPI.

备注Remarks

状态值通常为介于 -1 到 1 之间的规范化值。The status value is generally a normalized value between -1 and 1.

示例Example

下例将返回 Fiscal Year 属性层次结构中三个成员后代的渠道收入度量值的 KPI 值、KPI 目标、KPI 状态和 KPI 走向:The following example returns the KPI value, KPI goal, KPI status, and KPI trend for the channel revenue measure for the descendants of three members of the Fiscal Year attribute hierarchy:

SELECT  
   { KPIValue("Channel Revenue"),   
     KPIGoal("Channel Revenue"),  
     KPIStatus("Channel Revenue"),   
     KPITrend("Channel Revenue")  
   } ON Columns,  
Descendants  
   ( { [Date].[Fiscal].[Fiscal Year].&[2002],  
       [Date].[Fiscal].[Fiscal Year].&[2003],  
       [Date].[Fiscal].[Fiscal Year].&[2004]   
     }, [Date].[Fiscal].[Fiscal Quarter]  
   ) ON Rows  
FROM [Adventure Works]  

另请参阅See Also

MDX 函数引用 (MDX)MDX Function Reference (MDX)