Export (0) Print
Expand All
Expand Minimize

KPIValue (MDX)

Returns the member that calculates the value of the specified Key Performance Indicator (KPI).


KPIValue(KPI_Name)

KPI_Name

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

Example

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]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft