C2020-645 - IBM Cognos 10 BI Multidimensional Author Exam
Go back to IBM
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?
A set expression
What is a key difference between the total function and the aggregate function?
The aggregate function follows the rollup rules of the measure defined in the data source, and the total function adds the total of the specified measure.
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 values for all years. Why does this happen?
The default member from that dimension is implied.
A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product line level in the rows, and the year members (2004-2007) in the columns. How can the report author efficiently determine the difference in revenue between the years 2005 and 2006?
Create a new column as a query calculation, and create the expression -.
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?
No, this value-to-member drill-through is not a supported combination.
Which of the following family functions is most similar to the relative time function parallelPeriod?
If the syntax for the head function is head(set_exp[,index_exp]),then which of the following expressions is correct?
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?
Level order, level names
When a report author inserts Revenue into the Measures area of a blank crosstab report, which of the following statements is correct?
The report author has implicitly set the default measure for the crosstab report to be Revenue.
What functionality will allow the report consumer to focus the report each time it is run?
Use a prompt
A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be returned when the report is run?
3 months, including 2007/Mar and the preceeding 2 months
Which of the following are dimensional objects?
Query subject and relationship cardinality
When must a report author use the caption function?
To pass the returned value to a drill-through target report,this expects a matching string as a parameter value.
A report author can use a slicer to do what?
Provide context to intersection values
Which statement is true about MUNs?
They are used to retrieve members from the data source.
When the report consumer drills through from a dimensional member to a relational data item, what data type is passed?
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?
Mixing dimensional styles and relational styles in a single query can create unexpected results.
What dimensional function is used to return the members on the level below the Product line level?
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?
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?
A member from the level
What does the following expression do: "generate([Product line],topCount(descendants(currentMember([sales_and_marketing].[Products].[Products]), [sales_and_marketing].[Products].[Products].[Product]),2,[Revenue]))"?
Returns the top two products by revenue for each product line.
What type of prompt would a report author use to return a set of members from a hierarchy?
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?
Dimensional functions and slicers