Cube =CUBEMEMBER(connection, member_expression, [caption])

Quiz =CUBEMEMBER — 15 Questions

15 quiz questions about =CUBEMEMBER — test syntax, arguments, examples & errors!

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

← CUBEMEMBER ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many required arguments does =CUBEMEMBER have?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

What is the output type of =CUBEMEMBER?

Question 4 of 15 4/15

What usually causes #NAME? in =CUBEMEMBER?

Question 5 of 15 5/15

Is =CUBEMEMBER volatile?

Question 6 of 15 6/15

Which is the correct syntax of =CUBEMEMBER?

Question 7 of 15 7/15

In =CUBEMEMBER, which is argument #3?

Question 8 of 15 8/15

In =CUBEMEMBER, which is argument #2?

Question 9 of 15 9/15

How many optional arguments does =CUBEMEMBER have?

Question 10 of 15 10/15

Which statement about =CUBEMEMBER is correct?

Question 11 of 15 11/15

What is the fix for #NAME? in =CUBEMEMBER?

Question 12 of 15 12/15

Does =CUBEMEMBER return a dynamic array?

Question 13 of 15 13/15

Which function is NOT related to =CUBEMEMBER?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

What is the fix for #VALUE! in =CUBEMEMBER?

Click a question to see the answer.

1. How many required arguments does =CUBEMEMBER have?

A. 2 ✓
B. 3
C. 4
D. 1

Explanation: =CUBEMEMBER has 2 required, 1 optional (3 total).

2. What is the fix for #N/A in =CUBEMEMBER?

A. نام اتصال معتبر نیست یا سرور OLAP در دسترس نیست.
B. Requires add-in
C. Text is always ignored
D. نحو MDX، وجود عضو در کیوب و سازگاری ابعاد اعضای مجموعه را بررسی کنید. ✓

Explanation: CUBEMEMBER returns a #N/A error value when: The member_expression syntax is incorrect. CUBEMEMBER 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: نحو MDX، وجود عضو در کیوب و سازگاری ابعاد اعضای مجموعه را بررسی کنید.

3. What is the output type of =CUBEMEMBER?

A. Number
B. Mixed ✓
C. Text
D. Date

Explanation: Output is “Mixed”.

4. What usually causes #NAME? in =CUBEMEMBER?

A. حداقل یک عنصر درون تاپل نامعتبر است یا طول member_expression بیش از ۲۵۵ نویسه است.
B. If the connection name is not a valid workbook connection stored in the workbook, CUBEMEMBER returns a #NAME? error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBEMEMBER returns a #NAME? error value. ✓
C. Select entire column for best performance
D. نحو member_expression نادرست است، عضو در کیوب وجود ندارد، تاپل نامعتبر است، یا مجموعه دارای اعضای با ابعاد متفاوت است.

Explanation: If the connection name is not a valid workbook connection stored in the workbook, CUBEMEMBER returns a #NAME? error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBEMEMBER returns a #NAME? error value. — Fix: Check the connection name in the Connections section

5. Is =CUBEMEMBER volatile?

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

Explanation: CUBEMEMBER is not volatile.

6. Which is the correct syntax of =CUBEMEMBER?

A. =CUBEVALUE(connection, member_expression, [caption])
B. =CUBEMEMBER(connection, member_expression, [caption]) ✓
C. CUBEMEMBER(connection, member_expression, [caption])
D. =CUBEMEMBER(connection, member_expression, [caption], 0)

Explanation: Correct syntax: =CUBEMEMBER(connection, member_expression, [caption])

7. In =CUBEMEMBER, which is argument #3?

A. caption ✓
B. range
C. member_expression
D. value

Explanation: Argument #3 is “caption”.

8. In =CUBEMEMBER, which is argument #2?

A. lookup_value
B. value
C. member_expression ✓
D. caption

Explanation: Argument #2 is “member_expression”.

9. How many optional arguments does =CUBEMEMBER have?

A. 0
B. 2
C. 3
D. 1 ✓

Explanation: =CUBEMEMBER has 2 required, 1 optional (3 total).

10. Which statement about =CUBEMEMBER is correct?

A. Volatile and recalculates every time
B. When you use CUBEMEMBER as an argument to another CUBE function, the MDX expression that identifies the member or tuple is used by that CUBE function, not the displayed value in the cell of the CUBEMEMBER function.
C. When the CUBEMEMBER function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved. ✓
D. Select entire column for best performance

Explanation: Correct: When the CUBEMEMBER function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved.

11. What is the fix for #NAME? in =CUBEMEMBER?

A. Check the connection name in the Connections section ✓
B. Output is always a dynamic array
C. Text is always ignored
D. Only works in old versions

12. Does =CUBEMEMBER return a dynamic array?

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

Explanation: CUBEMEMBER does not spill.

13. Which function is NOT related to =CUBEMEMBER?

A. CUBEMEMBERPROPERTY
B. CUBEVALUE
C. TAKE ✓
D. CUBERANKEDMEMBER

Explanation: “TAKE” is not related to CUBEMEMBER.

14. What is the type of argument “caption” in =CUBEMEMBER?

A. Value
B. Text ✓
C. Array
D. Number

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

15. What is the fix for #VALUE! in =CUBEMEMBER?

A. اعضای تاپل را بررسی کنید و برای رشته‌های طولانی از مرجع سلول استفاده کنید. ✓
B. نام اتصال معتبر نیست یا سرور OLAP در دسترس نیست.
C. Output is always a dynamic array
D. Only works in old versions

Explanation: If at least one element within the tuple is invalid, CUBEMEMBER returns a #VALUE! error value. If member_expression is longer than 255 characters, which is the limit for an argument to a function, CUBEMEMBER returns a #VALUE! error value. — Fix: اعضای تاپل را بررسی کنید و برای رشته‌های طولانی از مرجع سلول استفاده کنید.