Excel Tutorial – CUBEKPIMEMBER

The CUBEKPIMEMBER function in Microsoft Excel is a database function that returns a key performance indicator (KPI) from a cube. It takes three arguments: the cube name, the KPI name, and the member name.

Here’s a step-by-step guide on how to use the CUBEKPIMEMBER function:

1. Open your Microsoft Excel spreadsheet and select the cell where you want to display the result.
2. Type the following formula into the selected cell: =CUBEKPIMEMBER(connection, kpi_name, member_name)
3. Replace “connection” with the name of the connection to the cube data source.
4. Replace “kpi_name” with the name of the KPI that you want to retrieve.
5. Replace “member_name” with the name of the member for which you want to retrieve the KPI value.

For example, if you want to retrieve the KPI “Sales Growth” for the member “Q1 2021” from the cube data source “Sales Data”, the formula would be: =CUBEKPIMEMBER(“Sales Data”, “Sales Growth”, “Q1 2021”)

6. Press Enter to complete the formula and display the result.

Note: The CUBEKPIMEMBER function is useful if you have a cube data source and want to retrieve specific KPI values. However, it is not a widely used function, as it requires a cube data source and specialized knowledge of KPI management.