Free IBM COG-645 Practice Test & Real Exam Questions

Exam Code/Number: COG-645
Exam Name/Title: IBM Cognos 10 BI Multidimensional Author
Certification Provider: IBM
Corresponding Certification: IBM Cognos

Exam Questions: 57
Updated On: Oct 28, 2026

Question #1

When would a report author define a set?

A. To use as a summary function to return the total of the specified members.

B. To change the crosstab node member properties for a level.

C. To create a slicer to focus on a specific number of years of data in a report.

D. To return members from different hierarchies of the same dimension.

Discussion 0

Correct Answer: C Vote an answer

Question #2

What dimensional function is used to return the members on the level below the Product line level?

A. Descendants

B. Set

C. members

D. Children

Discussion 0

Correct Answer: A Vote an answer

Question #3

In a crosstab, Campaign is in the rows area, Order method type is in the columns area, and Quantity is the measure. Campaign and Order method type are specified in the query. The report runs, displaying quantity values for all years. Why does this happen?

A. The order method member from that dimension is implied.

B. The dimension member from that dimension is implied.

C. The default member from that dimension is implied.

D. The aggregate member from that dimension is implied.

Discussion 0

Correct Answer: C Vote an answer

Question #4

A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What are the preferred techniques the report author would use to focus reports for this type of a data source?

A. Use Members directly

B. Dimensional functions and slicers

C. Ancestors and descendants

D. Detail filters and summary filters

Discussion 0

Correct Answer: B Vote an answer

Question #5

Which of the following is true if a report author nests members in a crosstab report?

A. Nested members must be members of hierarchies, not of the Measures folder.

B. It is possible to nest members from different dimensions.

C. The inner member must be on the level immediately below the outer member.

D. Nested members are also known as complex members.

Discussion 0

Correct Answer: B Vote an answer

Question #6

Instead of prompting the user to select any countries in Europe, the report author wants to constrain the user to select one or more countries from the Northern Europe region. What kind of prompt should be used and how can this be achieved?

A. Create a tree prompt, and populate it using an expression on the [Northern Europe] member to retrieve its children at the country level.

B. This is not possible because a prompt must always be populated with all members of a level.

C. Generate a prompt by creating an expression with aparameter on the crosstab edge:children([Northern Europe]->?Country?

D. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM COG-645 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM COG-645 exam.