An author creates a report in Report Studio. The report contains a parameter for the Product line query item. The author wants to let users drill through to this report from a variety of reports created using the GO Data Warehouse (query) package. To ensure that this target report contains data for the appropriate products, the author wants to limit the report cells that users can drill through from in source reports. What must the author do when creating the drill-through definition?
A. Set the Product line query item as the target of the drill-through definition.
B. Delete all data items except for the Product line query item from the drill-through definition.
C. Set the Product line query item as the scope of the drill-through definition.
D. Add a parameter for the Product line query to the drill-through definition.
正解:C
質問 2:
In Report Studio, when should authors use a Generated Prompt?
A. They are unsure of the most appropriate prompt type to choose.
B. They only want the user to be able to choose one option.
C. They want to use the same prompt on a prompt page and a report page.
D. They want the options to be based on selections made in another prompt.
正解:A
質問 3:
An author wants to create a filter on this report to only show Product line totals larger than 1 billion.
What calculation is used to create this filter?
A. Summary filter as: [Total(Revenue)]>1000000000Scope = Product line
B. Detail filter as: [Total (Revenue)]>1000000000Scope = Product line
C. Summary filter as: [Total(Revenue)] for [Product line]>1000000000)Application = After auto aggregation
D. Detail filter as: [Total (Revenue)] for [Product line] >1000000000Application = After auto aggregation
正解:A
質問 4:
In Report Studio, an author edits the SQL statement that a query uses to retrieve data for a crosstab. After editing the SQL, the author wants to add a new data item to the query. How can the author add the data item?
A. The author must add a query reference to the existing query and then add the data item to the referenced query.
B. The author must edit the SQL statement so that the query retrieves an additional data item.
C. The author must convert the edited SQL back to a query object and then add the data item.
D. The author must add the data item to the query from the package displayed on the Source tab.
正解:B
質問 5:
In Report Studio, an author creates a report using Package A.
Users should be able to drill through to target reports created for this package. What must the author do?
A. Enable package drill-through behavior for the report.
B. Add all drill-through definitions created for the package to the scope of the report.
C. Add all drill-through definitions created for the package as targets for the source report.
D. Add this report as a source report for each target created for the package.
正解:A