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