ExcelFlux

CUBEKPIMEMBER function

a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.

Cube · Guided Excel example

Where can you use it?

Data model and business intelligence teams. When checking measures, members and sets in a cube report, adapt the model and connection names to your workbook.

Scenario in the workbook

Compare KPI value, goal and status via three property codes. Replace column A with the real cube connection name. Match the sample MDX identifiers to your data model.

A worked example from the workbook

RowABC
6ConnectionMember or setSelection
7SalesCubeSales KPI1
8SalesCubeSales KPI2
9SalesCubeSales KPI3
Record 1
=CUBEKPIMEMBER(A7,B7,C7)

Illustrative outputDepends on model

See the inputs and instructions for all 3 examples

Worked examples

Compare KPI value, goal and status via three property codes. Replace column A with the real cube connection name. Match the sample MDX identifiers to your data model.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Connection Member or set Selection
7 SalesCube Sales KPI 1
8 SalesCube Sales KPI 2
9 SalesCube Sales KPI 3
Trial Expression Sample output
Record 1 =CUBEKPIMEMBER(A7,B7,C7) Depends on model
Record 2 =CUBEKPIMEMBER(A8,B8,C8) Depends on model
Record 3 =CUBEKPIMEMBER(A9,B9,C9) Depends on model
Microsoft Excel reference