Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-621

IBM C2090-621 Exam
IBM Cognos Analytics Author V11 (Page 5 )

Updated On: 12-Feb-2026
Page 4 of 22
PDF with 104 Questions

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



A report author has created this join relationship:


The Order number by product query includes only orders that contain a specific product selected at run time.

What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?

  1. Select “+” from the Operator drop down list.
  2. Select “=” from the Operator drop down list.
  3. Select “in” from the Operator drop down list.
  4. Select “>=” from the Operator drop down list.

Answer(s): B



The sales department has requested the report author to build a report which combines a list with a chart. The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report.
Which statement about Master detail relationships is true?

  1. Calculations across Master detail queries can be performed.
  2. Parent data in the child frame or child data in the parent frame can be displayed.
  3. Master detail relationships must appear in nested frames to produce the correct results.
  4. When working with an SAP BW Data source, a data item from the master query that contains non-ASCII values can be used.

Answer(s): C


Reference:

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_create_master_detail_relationship_rel.html



What should a report author do to use data from two tabs of an Excel file (.xlsx) together in a single object in a Dashboard?

  1. Upload each tab as one upload file and merge together within a data module.
  2. Upload each tab as separate upload files and merge together within a data module.
  3. Create separate Excel files for each tab, upload the files as one upload file and merge together within a data module.
  4. Create separate Excel files for each tab, upload the files as separate upload files and merge together within a data module.

Answer(s): D






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

Join the C2090-621 Discussion