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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
How many required arguments does =CUBEKPIMEMBER have?
Explanation: =CUBEKPIMEMBER has 3 required, 2 optional (5 total).
Question 2 of 10
2/10
Is argument “if” required in =CUBEKPIMEMBER?
Explanation: “if” is optional.
Question 3 of 10
3/10
What is the type of argument “kpi_name” in =CUBEKPIMEMBER?
Explanation: Type of “kpi_name” is “Text”.
Question 4 of 10
4/10
In =CUBEKPIMEMBER, which is argument #2?
Explanation: Argument #2 is “kpi_name”.
Question 5 of 10
5/10
Which function is related to =CUBEKPIMEMBER?
Explanation: “CUBEVALUE” is related to CUBEKPIMEMBER.
Question 6 of 10
6/10
What is the fix for #NAME? in =CUBEKPIMEMBER?
Explanation: If the connection name is not a valid workbook connection that is stored in the workbook, CUBEKPIMEMBER returns a #NAME? error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBEKPIMEMBER returns a #NAME? error value. — Fix: Check the connection name in the Connections section
Question 7 of 10
7/10
What is the output type of =CUBEKPIMEMBER?
Explanation: Output is “Mixed”.
Question 8 of 10
8/10
Which function is NOT related to =CUBEKPIMEMBER?
Explanation: “ASC” is not related to CUBEKPIMEMBER.
Question 9 of 10
9/10
Which statement about =CUBEKPIMEMBER is correct?
Explanation: Correct: When the CUBEKPIMEMBER function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved.
Question 10 of 10
10/10
Is argument “connection” required in =CUBEKPIMEMBER?
Explanation: “connection” is required.