IBM Cognos TM1 Developer V10.2 — Question 37

A company is using a model that was created in Compatible Query Mode (CQM). There is a report that must reference query subjects from two different packages.
How can this be accomplished?

Answer options

• A. The report author cannot create reports that reference multiple Data sources.
• B. The report author can add multiple packages to the reports as Data sources and create the report as needed.
• C. The report author must use SQL nodes for all queries that reference the data items in the two packages and join them appropriately to get the desired results within the report.
• D. The report author can use user-defined SQL to develop the query from one of the packages and the other package to develop the other query and then join them appropriately to get the desired results within the report.

Correct answer: D

Explanation

The correct answer is D because it allows the report author to effectively utilize user-defined SQL to create queries from both packages and join them as needed. Option A is incorrect since it states that referencing multiple data sources is not possible, which is false. Option B is misleading as it suggests that simply adding multiple packages will suffice without considering the need for proper query structuring. Option C incorrectly implies that SQL nodes are mandatory for all queries, which is not true when user-defined SQL can be used.