CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-621

Free C2090-621 Exam Braindumps (page: 4)

Page 3 of 27
PDF with 104 Questions

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

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

Answer(s): C


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?

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

Answer(s): C



A report author created a crosstab as shown below:

The crosstab report, when run, shows the following data:

The author wants to split the revenue for each region by year. Where should the year data item be added?

  1. Below Region using a horizontal drop zone.
  2. Above Region using a horizontal drop zone.
  3. To the left of Region using a vertical drop zone.
  4. To the right of Region using a vertical drop zone.

Answer(s): D



A report author wants to conditionally format data depending on a parameter value a user specifies at run time. How can this be done?

  1. By applying parameters directly in a variable.
  2. By using an HTML item to implement the parameter.
  3. By referencing a query item that uses the parameter.
  4. By applying the parameter in the color and background section of the properties.

Answer(s): A






Post your Comments and Discuss IBM C2090-621 exam with other Community members:

C2090-621 Discussions & Posts