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 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,…
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]…
To display all individual campaigns in a crosstab report, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign], [Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All…
Which of the following statements is true about a slicer? A. It keeps the summary column in the report, and removes the detail columns. B. It affects the values of the cells of the report but not the rows or…
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…
Which of the following is true if a report author nests members in a crosstab report? A. Nested members are also known as complex members. B. The inner member must be on the level immediately below the outer member. C.…
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. Configure the Ancestor drill…
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…
What is the default behavior when drilling down on an edge in a crosstab report? A. The level drilled on is replaced with the entire level below it. B. The edge expression is replaced with the children of the item…