The CUBEKPIMEMBER function returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization’s performance.

  • This function was introduced in Excel 2007 and so is not available in earlier versions.

Syntax

=CUBEKPIMEMBER(connection,kpi_name,kpi_property,[Caption])

Note: The CUBEKPIMEMBER function is supported only when the workbook is connected to a Microsoft SQL Server 2005 Analysis Services or later data source.

Arguments

Argument Description
connection A text string of the name of the connection to the cube
kpi_name A text string of the name of the KPI in the cube
kpi_property The KPI component returned and can be one of the following:

  Integer Enumerated constant Description
  1 KPIValue The actual value. If specified for kpi_property, only kpi_name is displayed in the cell
  2 KPIGoal A target value
  3 KPIStatus The state of the KPI at a specific moment in time
  4 KPITrend A measure of the value over time
  5 KPIWeight A relative importance assigned to the KPI
  6 KPICurrentTimeMember A temporal context for the KPI
[Caption] Optional. An alternative text string that is displayed in the cell instead of kpi_name and kpi_property

Examples

  A B
1 Formula  
2 =CUBEKPIMEMBER(“Sales”,”MySalesKPI”,1)  
3 =CUBEKPIMEMBER(“Sales”,”MySalesKPI”,KPIGoal,”Sales KPI Goal”)  

Common Function Error(s)

Problem What went wrong
#N/A! Occurs if either the kpi_name or kpi_property is invalid
#NAME? Occurs if either:

  the connection name is not a valid workbook connection that is stored in the workbook
  the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message