IBM Cognos 10 BI Multidimensional Author 試験
Question No : 1
A report author uses the following expression: lastPeriods(3,[2007/Mar]).
What data will be returned when the report is run?
Question No : 2
The report author creates a source report that contains values from "Products" on which the report consumer will drill through for details.
The report author has created a target report which expects a member from the source. Is this a supported drill-through combination?
Question No : 3
A report author creates a report with a drill-through definition. In the target report the parameter expression is "<Level expression> ->?P?".
What type of data must be passed to the parameter?
Question No : 4
The "Sales" and "Inventory" data stores each have "Products" and "Time" dimensions.
For drill-through between the data stores on the "Products" and "Time" dimensions to work, which items in the structures must be identical in the data stores?
Question No : 5
When the report consumer drills through from a dimensional member to a relational data item, what data type is passed?
Question No : 6
The report author uses the filter function to focus data in a report, but the results are unexpected.
What did the report author overlook when filtering the data?
Question No : 7
A report author creates a crosstab as shown.
What is the default measure of the report?
Question No : 8
A report author can use a slicer to do what?
Question No : 9
A report author is working with an OLAP data source. The report author creates a query that uses a caption function on a member and applies a string function.
What is a possible consequence of this action?
Question No : 10
The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?
Question No : 11
In the data source shown,
what dimensional component is selected?
Question No : 12
When a report author inserts Revenue into the Measures area of a blank crosstab report, which of the following statements is correct?
Question No : 13
Which statement is true about MUNs?
Question No : 14
Which of the following are dimensional objects?
Question No : 15
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?