What item will be returned?
Based on the diagram, if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned? A. 2005 Q 1 B. 2006 Q 4 C. 2006 Q 1 D. Nothing, because the return value equals the…
Based on the diagram, if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned? A. 2005 Q 1 B. 2006 Q 4 C. 2006 Q 1 D. Nothing, because the return value equals the…
Instead of prompting the user to select any countries in Europe, the report author wants to constrain the user to select one or more countries from the Northern Europe region. What kind of prompt should be used and how can…
Which of the following statements is correct about the order function? A. The currentMeasure function must be used with the order function as the sort by criterion. B. It arranges members of all sets in the report by ascending or…
Of the following prompt syntax expressions, which two are considered to be dimensional? 1) <expression> -> ?<prompt name>? 2) <expression> in (?<prompt name>?) 3) <expression> = ?<prompt name>? 4) set(<expression> -> ?<prompt name>?) A. 1 and 4 B. 1 and…
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,…
A report author creates an expression using the closingPeriod function to return the latest month found in the data source, and names the expression "Current Month". What can the report author do with "Current Month"? A. Use it to replace…
In a crosstab report, the report author wants a column to display a percentage of overall revenue that a particular product contributed to. Which of the following is a valid dimensional expression for this purpose? A. tuple([Revenue]/[Products]*[Revenue]) B. [Revenue]/([Revenue]*[Products]) C.…
The dialog box shown appears when a report is run. What should the report author do to correct the situation? A. Ask the modeler to rename the hierarchy to ‘[sales_and_marketing].[Products].[Products]. [Products]’, and to republish the package. B. Modify the expression…
Based on the crosstab displayed, the report author creates a singleton using the tuple function as follows: tuple([Camping Equipment],[Revenue], [2006]). Which of the following will appear in the singleton when the report is run? A. Camping Equipment, 500,382,422.83, 2006 B.…
What is a key difference between the total function and the aggregate function? A. The aggregate function can only summarize within a set, and the total function can accept separate members. B. The aggregate function is dimensional, and the total…