Download IBM.C2090-621.PracticeTest.2018-08-17.33q.tqb

Vendor:	IBM
Exam Code:	C2090-621
Exam Name:	IBM Cognos Analytics Author V11
Date:	Aug 17, 2018
File Size:	1 MB

Download Exam

Demo Questions

A report author has applied one style in specific cells, and another style for the overall report.

Which style will be applied?

The style on the specific cell is applied.
The style on the overall report is applied.
The last style in the Conditional styles property is applied.
The first style in the Conditional styles property is applied.

Correct answer: C

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_8.4.0/com.ibm.swg.im.cognos.ug_rptstd_fin.8.4.0.doc/ug_rptstd_fin_id3759cr_rptstd_modrep_highlight_data_con.html

A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/Region, Revenue and Unit Sale Price. The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot below shows the result:

What must the report author do for the report to look like the following?

Set the detail aggregation property to Automatic for each field.
Set the detail aggregation property to None for product line and order method. Total for Revenue. Average for Unit Sale Price.
Set the detail aggregation property to None for only Product Line and Order Method. Automatic for Revenue. Average for Unit Sale Price.
Set the detail aggregation property to Default for product line and Order method. Default for Revenue and Average for Unit Sale Price.

Correct answer: C

A report author created a crosstab as shown below: