Which of the following family functions is most similar to the relative time function parallelPeriod?
A. OpeningPeriod
B. Siblings
C. PrevMember
D. Cousin
正解:D
質問 2:
A crosstab report has product lines in the rows, years in the columns, and revenue as the
measure. In Query Explorer, from the source tree, the report author drags the order method Telephone to the Slicer pane. Why does the report author do this?
A. To return only one tuple.
B. To help to set the context.
C. To aggregate the telephone member.
D. To create an ordered set.
正解:B
質問 3:
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?
A. The parent member of the member drilled on.
B. The members from the Region level.
C. The members from the Retailer country level.
D. The ancestors of the member drilled on from the whole Retailers hierarchy.
正解:C
質問 4:
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 this be achieved?
A. This is not possible because a prompt must always be populated with all members of a level.
B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.
C. Generate a prompt by creating an expression with aparameter on the crosstab edge:children([Northern Europe]->?Country?
D. Create a tree prompt, and populate it using an expression on the [Northern Europe] member to retrieve its children at the country level.
正解:B
質問 5:
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 the lastPeriods(1,[Month]) expression currently in the report.
B. Use it to determine the current quarter: parent([Current Month]).
C. Use it as a report expression to display the current month in the page header of the report.
D. Add it to an expression to find the current member for the Month level.
正解:B
質問 6:
Assuming that Star products and Husky products are sets,
which statement below is correct about the sets in the graphic?
A. Each set is a grouping of members from different hierarchies.
B. The query displays each set as all the members of the level.
C. Each set can be sorted and aggregated.
D. The report creates a query for each member of the set.
正解:C