A customer wants to have a report with a bar chart, which is going to be displayed on a tablet. By changing a filter on the report, the chart should change dynamically. The report output size should be as small as possible.
How can this be achieved?
- A . Create an Active Report using visualizations. Check that the render method is set to Client.
- B . Create an Active Report using visualizations. Check that the render method is set to Server.
- C . Using a legacy chart with a conditional block around it. The block will be switched depending on the selected filters.
- D . Using a default chart with a conditional block around it. The block will be switched depending on the selected filters. Set the render method to Dynamic.
An author has finished working on a Dashboard and wants to make it available to other authors.
Where should the Dashboard be located?
- A . My content folder
- B . Team content folder
- C . Administration console, Mobile tab
- D . Administration console, Library tab
A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that it is displayed in.
How can this be done?
- A . Enable share result set on the list object.
- B . Create a join in the Query explorer to merge the data.
- C . Select the list and define a Master detail relationship.
- D . Select the chart and define a Master detail relationship.
How can a package be created?
- A . By combining Data modules.
- B . By using content administration.
- C . By publishing from a subset of a model.
- D . By using any valid non-relational Data source.
C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/SSEP7J_10.1.1/ com.ibm.swg.ba.cognos.ug_fm.10.1.1.doc/t_createormodifyapackage.html#CreateorModifyaPackage
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 > Add default values
- B . Select Button Bar control > Go to properties > Change User interface to checkbox
- C . Create a parameterized filter from the order_method > Manually populate the parameterized
- D . Select the Button Bar control > From the on-demand toolbar > Click the ellipsis > Point to convert control > Click check box group
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 control the position of each object on the report page layout.
- D . Choose the proper template and theme before starting the report development.
A business manager wants to set the current Dashboard as the home page.
Which mode allows this task?
- A . Run
- B . View
- C . Priority
- D . Review
An Active Report contains a data deck with the following values on multi select controls:
How many cards would be generated?
- A . 5
- B . 9
- C . 14
- D . 20
A report author has applied one style in specific cells, and another style for the overall report.
Which style will be applied?
- A . The style on the specific cell is applied.
- B . The style on the overall report is applied.
- C . The last style in the Conditional styles property is applied.
- D . The first style in the Conditional styles property is applied.
C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_8.4.0/ com.ibm.swg.im.cognos.ug_rptstd_fin.8.4.0.doc/ ug_rptstd_fin_id3759cr_rptstd_modrep_highlight_data_con.html
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 below shows the result:
What must the report author do for the report to look like the following?
- A . Set the detail aggregation property to Automatic for each field.
- B . Set the detail aggregation property to None for product line and order method. Total for Revenue. Average for Unit Sale Price.
- C . Set the detail aggregation property to None for only Product Line and Order Method. Automatic for Revenue. Average for Unit Sale Price.
- D . Set the detail aggregation property to Default for product line and Order method. Default for Revenue and Average for Unit Sale Price.
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 a horizontal drop zone.
- C . To the left of Region using a vertical drop zone.
- D . To the right of Region using a vertical drop zone.
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 the parameter.
- D . By applying the parameter in the color and background section of the properties.
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 . Select “+” from the Operator drop down list.
- B . Select “=” from the Operator drop down list.
- C . Select “in” from the Operator drop down list.
- D . Select “>=” from the Operator drop down list.
The sales department has requested the report author to build a report which combines a list with a chart. The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report.
Which statement about Master detail relationships is true?
- A . Calculations across Master detail queries can be performed.
- B . Parent data in the child frame or child data in the parent frame can be displayed.
- C . Master detail relationships must appear in nested frames to produce the correct results.
- D . When working with an SAP BW Data source, a data item from the master query that contains non-ASCII values can be used.
C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/ com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_create_master_detail_relationship_rel.html
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 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.
Which statement is true when a report author wants to optimize reports for mobile users?
- A . Set objects to a fixed size.
- B . Use margins between report objects.
- C . Size objects as a percentage of the available space.
- D . Use percentage sizes greater than one hundred percent (100%).
An author wants to include a corporate graphic in the Dashboard.
Which image format is supported?
- A . SVG
- B . BMP
- C . TIFF
- D . JPEG
D
Explanation:
Reference: http://www.wou.edu/datawarehouse/files/2016/06/ IBM_Cognos_Workspace_Advanced_User_Guide.pdf (page 155)
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?
- 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’.
A report author wants to display the report name on the report page.
Which type of calculation should be used?
- A . Field set
- B . Singleton
- C . Query calculation
- D . Layout calculation
D
Explanation:
Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21340054
A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.
How should the report be changed?
- A . Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.
- B . Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.
- C . Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Add a page set that is grouped on sales manager. Save the report.
- D . Add a repeater to the report. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Place the Crosstab within the repeater. Create a Master detail relationship between the Crosstab and the repeater on sales manager. Save the report.
A report author uploads files into Cognos Analytics C Reporting.
Which file formats are supported? (Choose two.)
- A . Microsoft Excel formatted single sheet worksheets.
- B . Any text or Microsoft Excel spreadsheet (xlsx or xls).
- C . Text files with data separated by commas, colons, tabs or semi-colons.
- D . Text files with data separated by commas, tabs, semi-colons or pipes.
- E . Text files must be fixed length without any separator denoting columns.
AC
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/ com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/c_rs_cwa_mng_ext_dta.html
A report author has been asked to create a list report with multiple facts from across the business. The desired outcome must ensure correlated and predictable results.
Which item must be included in the list report?
- A . Repeater table
- B . Conditional fact
- C . Model Query subject
- D . Conformed dimension
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?
- 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.
A report author has the following filter in a report:
[Product line] in ?pline?
The report author adds a Value prompt based on the existing parameter ‘pline’. After adding the prompt, the Auto-submit property is defaulted to ‘No’ and cannot be changed to ‘Yes’.
What is the cause of this?
- A . Default selections are missing in the Value prompt.
- B . The Value prompt created based on the filter is a Multi-select prompt.
- C . A prompt based on an existing parameter as Auto-submit cannot be made.
- D . Auto-submit is a property that is only available for select and search prompts.
A company would like to distribute reports to users via an email address or a directory entry.
How should the burst table be defined for this to work appropriately?
- A . Directory entries must not use the alternate path syntax.
- B . The burst table can be an uploaded file and contain as many columns as needed.
- C . The burst table must contain three columns (Recipient, Recipient type and Data item) to burst on.
- D . The directory entry can use either the alternate path syntax or the internal search path using the CAMID.
C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/ com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/ c_cr_rptstd_modrep_create_burst_table_in_source_database.html
A report author needs to create an offline interactive report that can be filtered by clicking on a list of values. For example, by clicking on Region “A” the List will display only the details from Region “A”.
Which Reaction behavior should be selected?
- A . Enable a control.
- B . Filter an item in a control.
- C . Select an item in a control.
- D . Create a report expression and use it in filters.
A report author needs to verify that the cardinality is set correctly in order to properly group a list report.
What is the correct setting?
- A . 1:1 cardinality from left to right
- B . 1:1 cardinality from right to left
- C . 1: n cardinality from left to right
- D . 1: n cardinality from right to left
A report author wants to create an Active Report with a chart that is dynamically rendered in the browser based on user selections.
How can this be accomplished?
- A . A legacy chart with client side processing.
- B . A legacy chart with server side processing.
- C . A Virtualization with client side processing.
- D . A Virtualization with server side processing.
A user is creating a join relationship in a Data module.
What benefit can be expected from setting a filter join?
- A . The performance on the join could be improved.
- B . The result set from the join would return less rows.
- C . The result set from the join would return more rows.
- D . The join relationship would work on multiple fields in each table.
A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/ com.ibm.swg.ba.cognos.dyn_query.10.2.2.doc/t_dqm_join_opt.html
A report author wants to add calculations that were created in the published package to a report.
Where can this be done?
- A . Macro tab
- B . Source tab
- C . Functions tab
- D . Parameter tab
B
Explanation:
Note that the analytic operations available depend on the data source you are using. Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/ com.ibm.swg.ba.cognos.ug_cr_qstd.10.2.2.doc/t_create_a_custom_calculation.html
An author wants to set a single value that will filter all other visualizations affected by its value.
Which visualization type should be used?
- A . Summary
- B . Tree map
- C . Data player
- D . Scatter plot
A report author has added a Button Bar control to an Active Report that allows users to view data for different regions. The report author now wants to make it possible for users to filter the report on multiple regions at once.
What should the report author do?
- A . Use the Static version of the Button Bar control.
- B . Use the Data-driven version of the Button Bar control.
- C . Convert the Button Bar control to a Check Box Group control.
- D . Convert the Button Bar control to a Radio Button Group control.
A company would like to implement their own corporate style across all reports using a single Report as a reference. A requirement is to display the year of the data selected in the report in the header.
The year is not being resolved correctly as shown below:
How can the problem with this report be resolved?
- A . The component reference has to be overwritten with a new defined “My Header Title” inside the new report.
- B . The component reference has to be overwritten with a new defined “MyYear Singleton” inside the new report.
- C . A component reference cannot contain a Singleton. The “Corporate Layout Reference” report has to be changed.
- D . A component reference cannot contain a Singleton. The reference cannot be used and the header has to be created manually.
A report author had created a single select value prompt using the prompt wizard. The end user now needs to select more than one value.
What should the report author do?
- A . Set the Auto-submit property of the Prompt to ‘Yes’ and change the Multi-select property of the value prompt to ‘Yes’.
- B . Set the Auto-Submit property of the Prompt to ‘Yes’ and change the parameterized filter associated with the prompt to the ‘in’ operator.
- C . Change the Multi-select property of the value prompt to ‘Yes’ and change the parameterized filter associated with the prompt to the ‘>’ operator.
- D . Change the Multi-select property of the value prompt to ‘Yes’ and change the parameterized filter associated with the prompt to the ‘in’ operator.
D
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/SSRL5J_1.0.1/ com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/ t_cr_rptstd_wrkdat_allow_users_select_multiple_values_prompt.html
A report author is building an Active Report for disconnected mobile use only.
Which technique can be used while ensuring the Active Report is fully offline capable?
- A . Creating a drill-through to a different PDF report.
- B . Setting a default value for a variable in the Active Report.
- C . Using an iFrame within the Active Report to another report.
- D . Adding a search and select prompt on a prompt page for the report consumer to filter the report on the iPad offline.
A report author wants to create an Active Report with a Data deck that only prompts for Product line and Year. For each card created, the Order method type broken down by revenue should be shown.
What needs to be done to ensure the data on each card reflects the correct year and Product line?
- A . Use a Repeater table in the Card deck.
- B . Each card should have a separate query.
- C . Filters should be copied from the Data deck to the cards.
- D . Use a Master detail relationship between the cards and the Data deck.
A report author has been asked to create a report that needs to be distributed in PDF format. The report has to let users navigate quickly to a desired report page and information within the report.
How can this be accomplished?
- A . Using a Hyperlink button.
- B . Creating an Active Report.
- C . Using a layout component reference.
- D . Using drill-through definitions and bookmarks for navigation.
D
Explanation:
Reference: https://www.ibm.com/developerworks/data/library/cognos/reporting/active_report/page593.html
What can be done when using a SQL object when not using a stored procedure?
- A . Update a database.
- B . Insert rows into database.
- C . Delete rows in a database.
- D . Select rows from a database.
Which Data source can a report author connect to directly when creating a Dashboard?
- A . a report
- B . a Data set
- C . a relational Data source
- D . a locally saved Excel file
A report developer is tasked to create a drill-through definition in a report.
Which are the generalized steps?
- A . Create the target report> Add parameter to target report> Save the target report> Set drill-through behavior
- B . Set drill-through behavior on each report> Select the correct package> Map parameter values passed to target report> Define source report
- C . Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable report variables for drill-through definitions> Save report
- D . Create the target report> Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable the drill behavior in the source report
A report author has to create a Crosstab report with Region and Product data in the rows of the Crosstab.
The Crosstab can be created in two different ways as shown below.
Which Crosstab/Crosstabs is/are discontinuous Crosstab/Crosstabs?
- A . Crosstab A
- B . Crosstab B
- C . Crosstab A and Crosstab B
- D . neither Crosstab A nor Crosstab B
A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/SSRL5J_1.0.1/ com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/t_cr_rptstd_reptyp_discontinuous_crosstab.html