IBM Cognos TM1 Developer V10.2 — Question 30

A report contains multiple queries that are joined to form the report, resulting in poor performance. The company's policy prohibits the use of user-defined SQL statements within reports.
What should be done to improve report performance?

Answer options

• A. Convert the report to use Native SQL statements.
• B. Move the appropriate filters to the underling queries.
• C. Change the Cross Product allowed property to be "Deny".
• D. Modify the Query Execution method to Concurrent to ensure that the underlying queries run at the same time.

Correct answer: D

Explanation

The correct answer is D because setting the Query Execution method to Concurrent allows the queries to execute in parallel, which can significantly enhance performance. Options A and B do not address the issue of query execution timing, and option C would restrict query combinations but does not improve overall performance.