Cube =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])

Quiz =CUBEKPIMEMBER — 10 Questions

10 quiz questions about =CUBEKPIMEMBER — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← CUBEKPIMEMBER ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is =CUBEKPIMEMBER volatile?

Question 2 of 10 2/10

In =CUBEKPIMEMBER, which is argument #1?

Question 3 of 10 3/10

Which function is related to =CUBEKPIMEMBER?

Question 4 of 10 4/10

What is the fix for #N/A in =CUBEKPIMEMBER?

Question 5 of 10 5/10

Which is the correct syntax of =CUBEKPIMEMBER?

Question 6 of 10 6/10

What is the type of argument “caption” in =CUBEKPIMEMBER?

Question 7 of 10 7/10

Is argument “if” required in =CUBEKPIMEMBER?

Question 8 of 10 8/10

Which function is NOT related to =CUBEKPIMEMBER?

Question 9 of 10 9/10

In =CUBEKPIMEMBER, which is argument #2?

Question 10 of 10 10/10

Which use case fits =CUBEKPIMEMBER?

Click a question to see the answer.

1. Is =CUBEKPIMEMBER volatile?

A. —
B. No ✓
C. No
D. Yes

Explanation: CUBEKPIMEMBER is not volatile.

2. In =CUBEKPIMEMBER, which is argument #1?

A. connection ✓
B. range
C. kpi_name
D. caption

Explanation: Argument #1 is “connection”.

3. Which function is related to =CUBEKPIMEMBER?

A. CUBEVALUE ✓
B. RSQ
C. T.TEST
D. NPV

Explanation: “CUBEVALUE” is related to CUBEKPIMEMBER.

4. What is the fix for #N/A in =CUBEKPIMEMBER?

A. نام KPI و ویژگی آن را بررسی کنید و در صورت اشتراک اتصال، از ارجاع به اعضای محاسبه‌شده مبتنی بر جلسه خودداری کنید. ✓
B. Volatile and recalculates every time
C. Output is always a dynamic array
D. Only works in old versions

Explanation: CUBEKPIMEMBER returns a #N/A error value when kpi_name or kpi_property is invalid. CUBEKPIMEMBER may return a #N/A error value if you reference a session-based object, such as a calculated member or named set, in a PivotTable when sharing a connection, and that PivotTable is deleted or you convert the PivotTable to formulas. (On the Options tab, in the Tools group, click OLAP Tools, and then click Convert to Formulas.) — Fix: نام KPI و ویژگی آن را بررسی کنید و در صورت اشتراک اتصال، از ارجاع به اعضای محاسبه‌شده مبتنی بر جلسه خودداری کنید.

5. Which is the correct syntax of =CUBEKPIMEMBER?

A. CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
B. =CUBEVALUE(connection, kpi_name, kpi_property, [caption])
C. =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption], 0)
D. =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption]) ✓

Explanation: Correct syntax: =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])

6. What is the type of argument “caption” in =CUBEKPIMEMBER?

A. Mixed
B. Value
C. Reference
D. Text ✓

Explanation: Type of “caption” is “Text”.

7. Is argument “if” required in =CUBEKPIMEMBER?

A. —
B. No
C. No ✓
D. Yes

Explanation: “if” is optional.

8. Which function is NOT related to =CUBEKPIMEMBER?

A. CUBEKPIMEMBER_X
B. IMABS ✓
C. CUBEMEMBER
D. CUBEVALUE

Explanation: “IMABS” is not related to CUBEKPIMEMBER.

9. In =CUBEKPIMEMBER, which is argument #2?

A. criteria
B. connection
C. kpi_name ✓
D. lookup_value

Explanation: Argument #2 is “kpi_name”.

10. Which use case fits =CUBEKPIMEMBER?

A. External Data, Web & Cube ✓
B. Conditional Logic
C. Text Manipulation
D. Dynamic Ranges & Dashboards

Explanation: Use case “External Data, Web & Cube” fits CUBEKPIMEMBER.