The report author creates a query where two items (TopThree and Retailer country) exist in the same member set. The expression for TopThree is: topCount([Retailer country],3,[Revenue]).
What drill behavior should the report author set in order to display the top three children instead of all children on drill down?
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 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?
What is the default behavior when drilling down on an edge in a crosstab report?
Based on the diagram,
if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?