IBM C2090-621 Dumps in PDF and Online - Page: 3

QUESTION: 11

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?

Below Region using a horizontal drop zone.
Above Region using a horizontal drop zone.
To the left of Region using a vertical drop zone.
To the right of Region using a vertical drop zone.

Answer(s): D

Reveal Solution Next Question

QUESTION: 12

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

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

Answer(s): A

Reveal Solution Next Question

QUESTION: 13

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?

Select “+” from the Operator drop down list.
Select “=” from the Operator drop down list.
Select “in” from the Operator drop down list.
Select “>=” from the Operator drop down list.

Answer(s): B

Reveal Solution Next Question

QUESTION: 14

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?

Calculations across Master detail queries can be performed.
Parent data in the child frame or child data in the parent frame can be displayed.
Master detail relationships must appear in nested frames to produce the correct results.
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

Reveal Solution Next Question

QUESTION: 15

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?

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

Answer(s): D

Reveal Solution Next Question

IBM Cognos Analytics Author V11 C2090-621 Dumps in PDF

Free IBM C2090-621 Real Questions (page: 3)

QUESTION: 11

QUESTION: 12

QUESTION: 13

QUESTION: 14

Reference:

QUESTION: 15