In a crosstab, Campaign is in the rows area, Order method type is in the columns area, and Quantity is the measure. Campaign and Order method type are specified in the query. The report runs, displaying quantity valuesfor all years.
Why does this happen?
A. The dimension member from that dimension is implied.
B. The order method member from that dimension is implied.
C. The aggregate member from that dimension is implied.
D. The default member from that dimensionis implied.
A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What are the preferred techniques the report author would use to focus reports for this type of a data source?
A. Dimensional functions and slicers
B. Use Members directly
C. Ancestors and descendants
D. Detail filters and summary filters
Which of the following are dimensional objects?
A. Sets and query calculation
B. Query subject andrelationship cardinality
C. Slicer and string function
D. Level and member
In the data source shown,
what dimensional component is selected?
A. Dimension
B. Hierarchy
C. Namespace
D. Level
A report author creates a report with a drill-through definition. In the target report the parameter expression is "
What type of data must be passed to the parameter?
A. A member from the level
B. Any member from the hierarchy
C. A value
D. A business key from the level
What functionality will allow the report consumer to focus the report each time it is run?
A. Filter a MUN
B. Use a prompt
C. Build a slicer
D. Use a dimensional function
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.
What dimensional function is used to return the members on the level below the Product line level?
A. Set
B. Children
C. Descendants
D. members
Can a prompt be used in the expression of a slicer?
A. Yes, if the correct syntax is used.
B. No, the slicer syntax is not compatible with prompt syntax.
C. Yes, if the slicer is a hierarchy.
D. No, the slicer must be manually created by the report author.
A report authorhas 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 parent member of the member drilled on.
B. The ancestors of the member drilled on from the whole Retailers hierarchy.
C. The members from the Region level.
D. The members from the Retailer country level.