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?
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?
The report author wants to create a report to compare the sales of product types for special sales promotions in 2005 and 2006, but the report will exclude regular sales. Which style of authoring and which function will the report author use to create this report from a cube data source?
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 report runs, and is 433 pages long, with 19,010 rows. Many of the rows are blank. The report author uses a filter function to filter nulls, and runs the report again. The result is 143 pages, with 6273 rows, and none of the rows are blank. What filtering style did the report author decide to use?