IBM Cognos TM1 Developer V10.2 — Question 1

A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report.
The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.
How should the report be changed?

Answer options

• A. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.
• B. Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.
• C. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Add a page set that is grouped on sales manager. Save the report.
• D. Add a repeater to the report. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Place the Crosstab within the repeater. Create a Master detail relationship between the Crosstab and the repeater on sales manager. Save the report.

Correct answer: A

Explanation

The correct answer is A, as it directly addresses the conversion of the list to a Crosstab, which is the primary requirement. Options B and C suggest adding or deleting components unnecessarily, while D complicates the process by introducing a repeater and master-detail relationship, which are not required for the task at hand.