Online Access Free C2090-645 Exam Questions

The following expression is used in a crosstab report: filter([sales_and_marketing]. [Product brand].[Product brand].[Product brand type],[Revenue]<100000000). There are 26 product brand types in the OLAP data source.

Why does the report only return 11 product brand type rows?

• A.A dimensional function was used to filter on each column.
• B.A relational function was used to filter on the measure values, not the members.
• C.A dimensional function was used to filter on the total of the opposite edge.
• D.A relational function was used to filter on the members, not the measure values.

A crosstab report has product lines in the rows, years in the columns, and revenue as the
measure. In Query Explorer, from the source tree, the report author drags the order method Telephone to the Slicer pane. Why does the report author do this?

• A.To help to set the context.
• B.To create an ordered set.
• C.To return only one tuple.
• D.To aggregate the telephone member.

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 ancestors of the member drilled on from the whole Retailers hierarchy.
• B.The members from the Region level.
• C.The parent member of the member drilled on.
• D.The members from the Retailer country level.

The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?

• A.A set expression
• B.An axis title
• C.A percent of base calculation
• D.The hierarchize function

Which of the following statements is true about explicitly defined member sets?

• A.They must have drill behavior defined manually.
• B.They are too complex to enable drilling.
• C.They assume the drill behavior from the top member set in the same branch.
• D.They are automatically configured for default drill behavior.