CUBEKPIMEMBER(connection, kpi_name, kpi_property [,caption])

Returns the name of a key performance indicator.

connectionThe name of the connection.
kpi_nameThe name of the KPI.
kpi_propertyThe type of component returned:
1 = KPIValue, the actual value
2 = KPIGoal, a target value
3 = KPIStatus, the status at that time
4 = KPITrend, a measure of the value over time
5 = KPIWeight, a relative importance assigned to the KPI
6 = KPICurrentTimeMember,
caption(Optional) The text to overwrite the kpi_name and kpi_property.

Remarks

* Added in Excel 2007.
* If "kpi_property" = 1, then only kpi_name is displayed.
* While the data is being retrieved #GETTING_DATA is displayed in the cell.
* For the Microsoft documentation refer to support.office.com

 AB
1=CUBEKPIMEMBER("Forecasts","MyForecastKPI",1)??
2=CUBEKPIMEMBER("Forecasts","MyForecastKPI",KPIGoal, "Forecast KPI Goal") 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top