Online Access Free COG-645 Practice Test

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

A report author creates a report with a drill-through definition. In the target report the parameter expression is "<Level expression> ->?P?". What type of data must be passed to the parameter?

• A.A value
• B.Any member from the hierarchy
• C.A business key from the level
• D.A member from the level

Based on the diagram,

if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?

• A.2006 Q 1
• B.2005 Q 1
• C.2006 Q 4
• D.Nothing, because the return value equals the parameter

In the data source shown, what dimensional component is selected?

• A.Namespace
• B.Hierarchy
• C.Level
• D.Dimension

Assuming that Star products and Husky products are sets,

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

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