IBM Cognos 10 BI Multidimensional Author: C2090-645

Based on the diagram,

if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?

A. 2005 Q 1

B. 2006 Q 4

C. 2006 Q 1

D. Nothing, because the return value equals the parameter

Which of the following statements is true about explicitly defined member sets?

A. They must have drill behavior defined manually.

B. They assume the drill behavior from the top member setin the same branch.

C. They are automatically configured for default drill behavior.

D. They are too complex to enable drilling.

A report author creates the following nestedreport using 2 adjacent levels of the same hierachy. Users should be able to drill down on the inner nesting with the outer nesting remaining unchanged.

What advanced drilling behavior should the report author use to achieve this?

A. Replace Expression

B. Depth Based Expression

C. Preserve

D. Replace Item