[2026] IBM Cognos 10 BI Multidimensional Author

문제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. Preserve the Sorted Products expression, but replace the underlying Product Set expression.

B. Nothing, as the default drill behavior is sufficient in this case, to maintain sorting of the children.

C. Configure the Ancestor drill behavior on the Sorted Products expression.

D. Set the behavior to Depth Based Expression, to maintain sorting at a lower level in the data source.

정답: A

문제2

A report author creates an expression using the closingPeriod function to return the latest month found in the data source, and names the expression "Current Month". What can the report author do with "Current Month"?

A. Use it as a report expression to display the current month in the page header of the report.

B. Use it to replace the lastPeriods(1,[Month]) expression currently in the report.

C. Add it to an expression to find the current member for the Month level.

D. Use it to determine the current quarter: parent([Current Month]).

정답: D

문제3

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

A. The edge expression is changed to another item in the query.

B. The level drilled on is replaced with the entire level below it.

C. The edge expression is replaced with the children of the item drilled on.

D. All edge expressions of the crosstab are replaced with their children.

정답: C

문제4

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. Limiting the crosstab measures with a filter function.

B. Filtering on measure values is incompatible with an OLAP data source.

C. A relational filter was applied.

D. There are too many members or levels nested on the row edge.

정답: C

문제5

Which term below best describes the selected cell in the crosstab?

A. Level

B. Tuple

C. member

D. Revenue

정답: B

문제6

A report author has created a crosstab report from the data source shown. The Retailer name level has been dragged to the rows and default drilling up and down has been activated.

What will be displayed in the report if the consumer drills up on one of the members of Retailer name?

A. The parent member of the member drilled on.

B. The members from the Retailer country level.

C. The ancestors of the member drilled on from the whole Retailers hierarchy.

D. The members from the Region level.

정답: B

IBM Cognos 10 BI Multidimensional Author - COG-645무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트