IBM Cognos TM1 Developer V10.2 — Question 70

A company's marketing report tracks performance of various advertising campaigns. All of the advertising media files are stored on an internal file server and can be accessed directly in the URI form file://adserver/adnnnnnn.mov (where nnnnnn is the same advertisement ID that's used in the marketing performance report).
How can the report author provide users with a clickable download link for the media file in the report performance list?

Answer options

• A. Add a Layout Calculation to the list as a new column with expression definition "˜file://adserver/ad' + [PerformanceQuery].[AdID] + "˜.mov'.
• B. Add a pair of HTML Items to the Ad Name list cell, using a Report Expression that includes "˜file://adserver/ad' + [PerformanceQuery].[AdID] + "˜.mov'.
• C. Add a Drill-through definition to the Ad Name list cell, using a Bookmark target with Report Expression of: "˜file://adserver/ad' + [PerformanceQuery].[AdID] + "˜.mov'.
• D. Insert an Image object into the Ad Name list cell, with URL Source Type set to Report Expression and using expression: "˜file://adserver/ad' + [PerformanceQuery].[AdID] + "˜.mov'.

Correct answer: D

Explanation

The correct answer is D because inserting an Image object with a URL Source Type set to Report Expression allows the media file to be displayed as a clickable link in the report. Options A, B, and C do not create a clickable link; they either provide calculations or expressions that do not function as direct download links.