- All Exams Instant Download
What must the report author do for the report to look like the following?
A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/Region, Revenue and Unit Sale Price. The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot...
How can this be accomplished?
A report author wants to enhance a report by having the ability to display the data by region and filter by Order method (where Order method includes: Email, Fax, Post, Sales rep, Promo, Phone, Web site). How can this be accomplished?A . Select On-demand toolbar > Select checkbox group >...
Which image format is supported?
An author wants to include a corporate graphic in the Dashboard. Which image format is supported?A . SVGB . BMPC . TIFFD . JPEGView AnswerAnswer: D Explanation: Reference: http://www.wou.edu/datawarehouse/files/2016/06/ IBM_Cognos_Workspace_Advanced_User_Guide.pdf (page 155)
What should be done first?
A report author is going to develop a report and wants to ensure that the layout if defined correctly. What should be done first?A . Modify the global class definitions for the specific objects.B . Select the objects that require changes and modify the properties.C . Add a table to...
Which type of calculation should be used?
A report author wants to display the report name on the report page. Which type of calculation should be used?A . Field setB . SingletonC . Query calculationD . Layout calculationView AnswerAnswer: D Explanation: Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21340054
What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?
A report author has created this join relationship: The Order number by product query includes only orders that contain a specific product selected at run time. What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?A...
How can the report author provide users with a clickable download link for the media file in the report performance list?
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 author wants to split the revenue for each region by year. Where should the year data item be added?
A report author created a crosstab as shown below: The crosstab report, when run, shows the following data: The author wants to split the revenue for each region by year. Where should the year data item be added?A . Below Region using a horizontal drop zone.B . Above Region using...
How can this be done?
A report author wants to conditionally format data depending on a parameter value a user specifies at run time. How can this be done?A . By applying parameters directly in a variable.B . By using an HTML item to implement the parameter.C . By referencing a query item that uses...
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?
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?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...
