Free C2090-645 Web TestEngine Demo

Q4 Single choice

The following expression is used to focus OLAP data in the rows of a report:
filter([sales_and_marketing].[Order method].[Order method].[Order method type], [Revenue]>150000000).

Which of the following statements describes the purpose of the expression?

A
To return the set of members whose revenue is less than150000000 for any year.
B
To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.
C
To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.
D
To filter the years to show those having revenues greater than 150000000 by order method type.

C2090-645 Web TestEngine demo