Quality and Value
Complete questions
Secure Payment
100% GuaranteeFree IBM COG-145 Braindumps Demo
Latest ExamQA COG-145 exam questions and training dumps pdf demo free download.
|
Number/Code: COG-145 Exam Name: IBM Cognos 8 BI Multidimensional Author Questions and Answers: 57 Q&As Updated: Wed, 02 May 2012 Version: 13.4 List Price: Price: $ 59.00 33
|
Free COG-145 training materials demo download
COG-145 Demo(IBM Cognos 8 BI Multidimensional Author): allows you to check out the interface, question quality and usability of our practice exams.
Product preview does not include questions pictures, I suggest you download the PDF version for viewing.
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
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 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
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
4.The following expression is used to focus OLAP data in the rows of a report: filter([sales_and_marketing].[Order method].[Order method].[Order method type], [Revenue]>150000000).
Which of the following statements describes the purpose of the expression?
A.To return the set of members whose revenue is less than 150000000 for any year.
B.To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.
C.To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.
D.To filter the years to show those having revenues greater than 150000000 by order method type.
Answer:B
5.What dimensional function is used to return the members on the level below the Product line level?
A.Tail
B.Lag
C.Descendants
D.BottomCount
Answer:C
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
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 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
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
4.The following expression is used to focus OLAP data in the rows of a report: filter([sales_and_marketing].[Order method].[Order method].[Order method type], [Revenue]>150000000).
Which of the following statements describes the purpose of the expression?
A.To return the set of members whose revenue is less than 150000000 for any year.
B.To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.
C.To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.
D.To filter the years to show those having revenues greater than 150000000 by order method type.
Answer:B
5.What dimensional function is used to return the members on the level below the Product line level?
A.Tail
B.Lag
C.Descendants
D.BottomCount
Answer:C