IBM Cognos TM1 Developer V10.2 — Question 27

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?

Answer options

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

Correct answer: D

Explanation

The correct answer is D because it involves creating separate Excel files for each tab, which is necessary for proper data organization. Uploading them as separate files allows for better management and merging in the data module. Options A, B, and C do not follow the required process for merging data from two tabs effectively.