| Test information: Test COG-145: IBM Cognos 8 BI | | | | total function is relational. |
| Multidimensional Author | | | | C.The aggregate function will summarize only the |
| - Number of questions: 57 | | | | currentMeasure, and the total function will |
| - Time allowed in minutes: 60 | | | | summarizeany specified measure. |
| - Required passing score: 75% | | | | D.The aggregate function follows the rollup rules |
| Free real questions and answers you can read | | | | of the measure defined in the data source, and |
| here : | | | | the totalfunction adds the total of the specified |
| A report runs, and is 433 pages long, with 19,010 | | | | measure. |
| rows. Many of the rows are blank. The report | | | | Answer:D |
| authoruses a filter function to filter nulls, and runs | | | | A report author uses an OLAP cube to create a |
| the report again. The result is 143 pages, with | | | | crosstab with Revenue as a measure, the |
| 6273 rows, andnone of the rows are blank. What | | | | Product linelevel in the rows, and the year |
| filtering style did the report author decide to use? | | | | members (2004-2007) in the columns. How can |
| A.Conventional | | | | the report author efficientlydetermine the |
| B.Dimensional | | | | difference in revenue between the years 2005 |
| C.Relational | | | | and 2006? |
| D.Functional | | | | A.Determine MUNs for the years 2005 and 2006, |
| Answer:B | | | | and then create an expression using the MUNs. |
| What is a key difference between the total | | | | B.Create a new column as a query calculation, and |
| function and the aggregate function? | | | | create the dimensional expression [2006]-[2005]. |
| A.The aggregate function can only summarize | | | | C.Create a set of the 2005 and 2006 members |
| within a set, and the total function can accept | | | | and aggregate it. |
| separatemembers. | | | | D.Ask the modeler to create a calculated |
| B.The aggregate function is dimensional, and the | | | | category in Transformer and then use it directly. |