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

Question 1

What does the following expression do: "generate([Product line],topCount(descendants(currentMember([sales_and_marketing].[Products].[Products]),[sales_a nd_marketing].[Products].[Products].[Product]),2,[Revenue]))"?

A. Finds the top two members by revenue at the product level and returns their respective ancestors at the product line level. B. Calculates the top two product lines for each product. C. Returns the top two products by revenue for each product line. D. Goes two levels up from products and returns the top members by revenue at that level.

Discussion 0

Correct Answer: C Vote an answer

Question 2

What is the default behavior when drilling down on an edge in a crosstab report?

A. The edge expression is replaced with the children of the item drilled on. B. The edge expression is changed to another item in the query. C. The level drilled on is replaced with the entire level below it. D. All edge expressions of the crosstab are replaced with their children.

Discussion 0

Correct Answer: A Vote an answer

Question 3

What is true about MUNs?

A. A MUN is a key with a unique value at each level. B. A MUN is a category code that is generated when the cube is built. C. A MUN is a business key that allows drill through between packages. D. A MUN contains the fully qualified path to a member.

Discussion 0

Correct Answer: D Vote an answer

Question 4

What type of prompt would a report author use to return a set of members from a hierarchy?

A. Tree prompt B. Select and Search Prompt C. Prompt Page D. Value prompt

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which of the following statements is correct about the order function?

A. Optional parameters allow the author to order the members of a hierarchy without regard of their level. B. It arranges members of all sets in the report by ascending or descending values. C. The currentMeasure function must be used with the order function as the sort by criterion. D. It arranges members of a set alphabetically by ascending or descending captions.

Discussion 0

Correct Answer: A Vote an answer

Question 6

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