C2020-645 - IBM Cognos 10 BI Multidimensional Author Exam

Go back to IBM

Example Questions

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? What is a key difference between the total function and the aggregate function? 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? 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? 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? 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? When a report author inserts Revenue into the Measures area of a blank crosstab report, which of the following statements is correct? What functionality will allow the report consumer to focus the report each time it is run? A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be returned when the report is run? Which of the following are dimensional objects? When must a report author use the caption function? A report author can use a slicer to do what? Which statement is true about MUNs? 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? 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? 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]))"? 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?