Menu
EXCEL CUBEKPIMEMBER FUNCTION
Excel CUBEKPIMEMBER Function Introduction
This function returns a key performance indicator (KPI) property and displays the name of the KPI in the cell. A key performance indicator (KPI) is a measurable metric, such as monthly gross profit or quarterly staff turnover, that is used to assess an organization’s performance.
Description of Excel CUBEKPIMEMBER Function
Syntax:
=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [Optional caption])
Parameter:
- The following arguments are passed to the CUBEKPIMEMBER function syntax
- Connectivity is required. A text string containing the name of the cube connection.
- Kpi name – This field is required. The name of the KPI in the cube as a text string.
- Kpi property – This is required. The KPI component that was returned might be one of the following:
Only kpi name is displayed in the cell if you set KPIValue for kpi property. - Optional caption. A text string that is shown in place of kpi name and kpi property in the cell.
When the CUBEKPIMEMBER function evaluates, the cell shows a “#GETTING DATA…” message until all of the data is retrieved.
Step By Step Guide of CUBEKPIMEMBER Function
Example :
=CUBEKPIMEMBER(“Sales”,”MySalesKPI”,1)
=CUBEKPIMEMBER(“Sales”,”MySalesKPI”, KPIGoal,”Sales KPI Goal”)
Key Points
- To use the KPI in a computation, use the CUBEVALUE function with the
- CUBEKPIMEMBER function as a member expression parameter.
CUBEKPIMEMBER returns a #NAME? error value if the connection name is not a valid workbook connection that is stored in the workbook. - CUBEKPIMEMBER delivers a #NAME? error value if the Online Analytical Processing (OLAP) server is not operating, is unavailable, or gives an error message.
- If you refer a session-based object, like as a calculating component or unnamed set, in a PivotTable whilst sharing a relationship and that PivotTable is removed or converted to formulae, CUBEKPIMEMBER may receive a #N/A error result. (On the Options tab, under the Tools group, select OLAP Tools, followed by Conversion to Formulas.)
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
