Buzz
In addition, to learn more about other Excel functions like CUBEVALUE, CUBESET function in Excel. Readers can refer to some articles already available on Mytour. In this article, Mytour will provide information, examples related to the CUBEKPIMEMBER function in Excel, returns the KPI attribute.
CUBEKPIMEMBER function and syntax
1. Description of CUBEKPIMEMBER function in Excel
The CUBEKPIMEMBER function in Excel returns the KPI attribute (key performance indicator attribute) and displays the KPI name in the cell. KPI is a quantifiable measure, such as monthly gross profit or employee turnover, used to track performance in an organization.
Note: The CUBEKPIMEMBER function is only supported when the workbook is connected to Microsoft SQL Server 2005 Analysis Services or a newer data source.
2. Syntax of CUBEKPIMEMBER function in Excel, returning the KPI attribute
Syntax of CUBEKPIMEMBER function in Excel, returning the KPI attribute is as follows:
CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
Where:
- The Connection argument is required. It is a text string name of the connection to the cube.
- The Kpi_name argument is required. It is a text string name of the KPI in the cube.
- The Kpi_property argument is required. The KPI property to be returned and can be one of the following:
If KPIValue is specified for kpi_property, only kpi_name will be displayed in the cell.
- The Caption argument is optional. It is a text string replacement displayed in the cell instead of kpi_name and kpi_property.
3. Important notes about the CUBEKPIMEMBER function in Excel, returning the KPI attribute
- When the CUBEKPIMEMBER function evaluates, it will temporarily display the message '#GETTING_DATA...' in the cell before all data is retrieved.
- To use KPIs in calculations, specify the CUBEKPIMEMBER function as the member_expression argument in the CUBEVALUE function.
- If the connection name is not a valid workbook connection stored in the workbook, the CUBEKPIMEMBER function will return the #NAME? error. If the Online Analytical Processing (OLAP) server is not running, unavailable, or returns an error message, the CUBEKPIMEMBER function will return the #NAME? error.
- The CUBEKPIMEMBER function in Excel returns the #N/A error when kpi_name or kpi_property is invalid.
- The CUBEKPIMEMBER function in Excel may return the #N/A error if you reference an object based on session, such as a calculated item or set name in a PivotTable when sharing connections and the PivotTable is deleted or converted to formulas. (In the Options tab, in the Tools group, click OLAP Tools, then click Convert to Formulas).
4. Example of the CUBEKPIMEMBER function in Excel, returning the KPI attribute
=CUBEKPIMEMBER('Sales','MySalesKPI',1)
=CUBEKPIMEMBER('Sales','MySalesKPI', KPIGoal,'Sales KPI Goal')
This article introduces you to the CUBEKPIMEMBER function in Excel, returning the KPI attribute. Additionally, you can learn more about functions like Index or Match in Excel, especially when combining the Index and Match functions, the problem will be solved much faster than applying single functions, refer to the article combining the Index and Match functions here.
