TechNet
Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Collapse the table of content
Expand the table of content
Expand Minimize

KPIStatus (MDX)

 

Updated: March 2, 2016

Returns a normalized value that represents the status portion of the specified Key Performance Indicator (KPI).


KPIStatus(KPI_Name)

KPI_Name
A valid string expression that specifies the name of the KPI.

The status value is generally a normalized value between -1 and 1.

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]

MDX Function Reference (MDX)

Community Additions

ADD
Show:
© 2016 Microsoft