20
Feb
2010
To achieve the IBM Certified Designer
To achieve the IBM Certified Designer - Cognos 8 BI Multidimensional Reports certification, candidates
must possess the skills identified under Recommended Prerequisite Skills, if any, and pass one (1) exam.
Former exam code was BI0-145.
Test information:
Number of questions: 57
Time allowed in minutes: 60
Required passing score: 75%
Study material: Testpassport real IBM Cognos COG-145 Q&A study guide
Sample / Assessment test:
Test your knowledge prior to taking the test.
Related certifications:
IBM Certified Designer – Cognos 8 BI Multidimensional Reports
IBM Certified Solution Expert – Cognos 8 BI
6
Jan
2010
IBM Cognos COG-145 share in testpassport
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
PDF: http://pdf.testpassport.com/COG-145.pdf
software: http://demo.testpassport.com/COG-145.zip
4
Dec
2009
IBM Cognos COG-145 share study guide
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 currentMeasure, 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
more visit here: http://www.testpassport.com/IBM-Cognos/COG-145.asp