CUBEKPIMEMBER Function Explained
The CUBEKPIMEMBER Function in Microsoft Excel returns a key performance indicator (KPI) value from an OLAP cube. It takes three arguments: Cube_Name, KPI_Name, and KPI_Property. The Cube_Name argument is the name of the OLAP cube from which the KPI value is retrieved. The KPI_Name argument is the name of the KPI from which the value is retrieved. The KPI_Property argument is the property of the KPI from which the value is retrieved.
CUBEKPIMEMBER Function Syntax
CUBEKPIMEMBER(cube_name, kpi_name, [member_name], [property_name])
- cube_name: The name of the cube from which to retrieve the KPI.
- kpi_name: The name of the KPI to retrieve.
- member_name: (Optional) The name of the member to retrieve the KPI from. If omitted, the KPI is retrieved from the default member.
- property_name: (Optional) The name of the property to retrieve from the KPI. If omitted, the value of the KPI is returned.