When a report author inserts Revenue into the Measures area of a blank crosstab report, which of thefollowing statements is correct?
A. The report author has implicitly set the default measure for the crosstab report to be Revenue.
B. The report author must verify the aggregation properties of Revenue to make sure it will display correctly.
C. Thereport author has declared a currentMember function to return the Revenue data.
D. The report author must validate the expression for Revenue to ensure there are no crosstab errors.
Consumers want a report to compare the revenue and quantity sold for all product lines in a selected quarter, to the same quarter for the previousyear. They also want to see the total for periods, up to and including the quarter selected.
Which of the following dimensional functions could the report author use to create this report?
A. Ancestor, currentMember, lead, total
B. OpeningPeriod, order, quarter, Firstsibling
C. Cousin, tuple, closingPeriod, aggregate
D. ParallelPeriod, tuple, periodsToDate, aggregate
When must a report author use the caption function?
A. As the first parameter of the roleValue function.
B. To return the display name for thespecified business key.
C. To see the string display name for the specified element.
D. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.
A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product linelevel in the rows, and the year members (2004-2007) in the columns.
How can the report author efficiently determine the difference in revenue between the years 2005 and 2006?
A. Determine MUNs for the years 2005 and 2006, and then create an expressionusing the MUNs.
B. Create a new column as a query calculation, and create the expression [2006]-[2005].
C. Create a set of the 2005 and 2006 members and aggregate it.
D. Ask the modeler to create a calculated category in Transformer and then use it directly.
What type of prompt would a report author use to return a set of members from a hierarchy?
A. Select and Search Prompt
B. Value prompt
C. Tree prompt
D. Prompt Page
Which of the following statements is correct about the order function?
A. The currentMeasure function must be used with the orderfunction as the sort by criterion.
B. It arranges members of all sets in the report by ascending or descending values.
C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.
D. It arranges members of a set alphabetically by ascending or descending captions.
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 membermust be on the level immediately below the outer member.
C. Nested members must be members of hierarchies, not of the Measures folder.
D. It is possible to nest members from different dimensions.
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 columns.
C. It determines which set of members are displayed onthe edges of the report.
D. It removes all blank rows in the report to make it more focused.
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. There are too many members or levels nested on the rowedge.
B. Filtering on measure values is incompatible with an OLAP data source.
C. Limiting the crosstab measures with a filter function.
D. A relational filter was applied.
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 relational function was used to filter on the measure values, not the members.
B. A dimensional functionwas used to filter on each column.
C. A relational function was used to filter on the members, not the measure values.
D. A dimensional function was used to filter on the total of the opposite edge.
