IBM Cognos 10 BI Multidimensional Author - COG-645 Exam Questions [2026]

QUESTION NO: 1
Assuming that Star products and Husky products are sets,

which statement below is correct about the sets in the graphic?

A. The report creates a query for each member of the set. B. Each set is a grouping of members from different hierarchies. C. Each set can be sorted and aggregated. D. The query displays each set as all the members of the level.

Correct Answer: C

QUESTION NO: 2
Which of the following statements is true about a slicer?

A. It keeps the summary column in the report, and removes the detail columns. B. It removes all blank rows in the report to make it more focused. C. It affects the values of the cells of the report but not the rows or columns. D. It determines which set of members are displayed on the edges of the report.

Correct Answer: C

QUESTION NO: 3
If the syntax for the head function is head(set_exp[,index_exp]),then which of the following expressions is correct?

A. head(members([sales_and_marketing].[Products].[Products].[Product line]),2) B. head(order([sales_and_marketing].[Products].[Products].[Product line])2) C. head(members([sales_and_marketing].[Products].[Products].[Product line],2)) D. head(([sales_and_marketing].[Products].[Products].[Product line])[,2])

Correct Answer: A

QUESTION NO: 4
To display all individual campaigns in a crosstab report, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All Campaigns])". Which statement is true about the method that was used?

A. To be accurate, the report author should avoid using a set expression. B. The report author should not have used the method chosen, as the first method is best in this situation. C. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression. D. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.

Correct Answer: D

QUESTION NO: 5
A report author creates a revenue report from an OLAP data source. On the rows, there are nested levels, each from different dimensions having a large number of members. The report author filters out empty rows using the expression "[Revenue] > 0". When running this report, there is poor performance. What could cause this?

A. Filtering on measure values is incompatible with an OLAP data source. B. A relational filter was applied. C. There are too many members or levels nested on the row edge. D. Limiting the crosstab measures with a filter function.

Correct Answer: B

QUESTION NO: 6
To create a report from the data source shown, what entities will the report author use?

A. Values B. MUNs C. Members D. Attributes

Correct Answer: A