IBM Cognos 10 BI Multidimensional Author - C2090-645 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

The author has created a complex expression called "Sorted Products" on the row edge, which sorts product line by Revenue for 2006.

What must the report author do to sort the members when drilling down?

A. Configure the Ancestor drill behavior on the Sorted Products expression. B. Set the behavior to Depth Based Expression, to maintain sorting at a lower level in the data source. C. Nothing, as the default drill behavior is sufficient in this case, to maintain sorting of the children. D. Preserve the Sorted Products expression, but replace the underlying Product Set expression.

Discussion 0

Correct Answer: D Vote an answer

Question 2

The dialog box shown appears when a report is run.

What should the report author do to correct the situation?

A. Modify the expression to 'currentMember([sales_and_marketing].[Products].[Products])'. B. Modify the expression to change the 'currentMember' function to 'currentLevel'. C. Modify the expression to change the 'currentMember' function to 'currentHierarchy'. D. Ask the modeler to rename the hierarchy to '[sales_and_marketing].[Products].[Products].[Products]', and to republish the package.

Discussion 0

Correct Answer: A Vote an answer

Question 3

The "Sales" and "Inventory" data stores each have "Products" and "Time" dimensions. For drill-through between the data stores on the "Products" and "Time" dimensions to work, which items in the structures must be identical in the data stores?

A. Hierarchy names, member values B. Level order, level names C. Role value, internal keys D. Hierarchy names, snowflake schema

Discussion 0

Correct Answer: B Vote an answer

Question 4

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

A. They are too complex to enable drilling. B. They are automatically configured for default drill behavior. C. They assume the drill behavior from the top member set in the same branch. D. They must have drill behavior defined manually.

Discussion 0

Correct Answer: D Vote an answer

Question 5

What functionality will allow the report consumer to focus the report each time it is run?

A. Use a prompt B. Use a dimensional function C. Filter a MUN D. Build a slicer

Discussion 0

Correct Answer: A Vote an answer

Question 6

A report runs, and is 433 pages long, with 19,010 rows. Many of the rows are blank. The report author uses a filter function to filter nulls, and runs the report again. The result is 143 pages, with 6273 rows, and none of the rows are blank. What filtering style did the report author decide to use?

A. Dimensional B. Relational C. Conventional D. Functional

Discussion 0

Correct Answer: A Vote an answer