Demo Edition
© 2008 - 2009 Test Killer, LTD All Rights Reserved
IBM Cognos 8 BI Multidimensional Author
Exam: COG-145
COG-145
1
http://www.testkiller.com
http://www.troytec.com
QUESTION: 1
A report runs, and is 433 pages long, with 19,010 rows. Many of the rows are blank. The
report author uses a filter function to filter nulls, and runs the report again. The result is 143
pages, with 6273 rows, and none of the rows are blank. What filtering style did the report
author decide to use?
A. Conventional
B. Dimensional
C. Relational
D. Functional
Answer: B
QUESTION: 2
What is a key difference between the total function and the aggregate function?
A. The aggregate function can only summarize within a set, and the total function can
accept separate members.
B. The aggregate function is dimensional, and the total function is relational.
C. The aggregate function will summarize only the current Measure, and the total function
will summarize any specified measure.
D. 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.
Answer: D
QUESTION: 3
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?
A. Determine MUNs for the years 2005 and 2006, and then create an expression using the
MUNs.
B. Create a new column as a query calculation, and create the dimensional expression
[2006]-[2005].
C. Create a set of the 2005 and 2006 members and aggregate it.
D. Ask the modeler to create a calculated category in Transformer and then use it directly.
Answer: B
COG-145
2
http://www.testkiller.com
http://www.troytec.com
QUESTION: 4
The following expression is used to focus OLAP data in the rows of a report:
filter([sales_and_marketing].[Order method].[Ord