IBM Cognos TM1 Developer V10.2 — Question 73

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 soft the Crosstab appropriately. Add a page set that is grouped on sales manager.
• 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 because it directly utilizes the convert list to Crosstab option, which is the simplest method to achieve the desired format while maintaining the existing data structure. Options B, C, and D introduce unnecessary complexity or different approaches that do not align with the request for a straightforward conversion to Crosstab format.