keep in mind javascript is required for full website functionality.
Welcome back to our regular blog of Excel functions from A to Z. Today we look at the CUBEKPIMEMBER function.
The CUBEKPIMEMBER function
When the workbook is connected to a Microsoft SQL Server 2005 Analysis Services or a later data source, tThis function returns a KPI property (KPIKPIs, o Key performance indicators, These are metrics used by organizations to evaluate their success in achieving specific goals. These indicators allow you to monitor progress and make informed decisions. There are different types of KPIs, which may vary depending on the sector and the strategic objectives of the company. Its correct implementation is essential to improve the efficiency and effectiveness of operations....) and displays the name of the KPI in the cell. Un KPI es una measureThe "measure" it is a fundamental concept in various disciplines, which refers to the process of quantifying characteristics or magnitudes of objects, phenomena or situations. In mathematics, Used to determine lengths, Areas and volumes, while in social sciences it can refer to the evaluation of qualitative and quantitative variables. Measurement accuracy is crucial to obtain reliable and valid results in any research or practical application.... cuantificable, such as monthly gross profit or quarterly employee turnover, used to monitor the performance of an organization.
The CUBEKPIMEMBER The function uses the following syntax to operate:
CUBEKPIMEMBER (Connection, kpi_name, kpi_property, )
The CUBEKPIMEMBER The function has the following arguments:
- Connection: this is mandatory and represents a text string of the name of the connection to the cube
- kpi_name: this is also necessary. This is a text string of the name of the KPI in the cube.
- kpi_property: again, this is obligatory. This is the returned KPI component and it can be one of the following:
- subtitle: this is optional. This represents an alternative text string that is displayed in the cell instead of kpi_name Y kpi_property.
It should also be noted that:
- the CUBEKPIMEMBER The function is supported only when the workbook is connected to a Microsoft SQL Server 2005 Analysis Services or a later data source.
- when the CUBEKPIMEMBER The function evaluates, temporarily display a message “# GETTING_DATA …” in cell before all data is retrieved.
- to use the KPI in a calculation, specify the CUBEKPIMEMBER function as a member_expression argument in the CUBEVALUE function
- if the connection name is not a valid workbook connection that is stored in the workbook, CUBEKPIMEMBER returns a #NAME? error value. If the online analytical processing server (OLAP) it's not working, is not available or returns an error message, CUBEKPIMEMBER returns a #NAME? error value
- CUBEKPIMEMBER returns a #N / A error value when kpi_name O kpi_property is invalid
- if you specify KPIValue by kpi_property, only kpi_name displayed in cell
- CUBEKPIMEMBER can return a #N / A error value if you reference a session-based object, as a calculated member or named set, in a pivot table when a connection is shared, and that pivot table is dropped or converts pivot table to formulas (in the 'Options' tab’ of the tape , in the group 'Tools', click on 'OLAP Tools’ and then click on 'Convert to formulas').
Please, see my examples below:
= CUBEKPIMEMBER (“Sales”, “MySalesKPI”, 1)
= CUBEKPIMEMBER (“Sales”, “MySalesKPI”, KPIGoal, “Sales KPI target”)
Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every business day.
Sign up to receive our newsletter